15 Feb
2018
15 Feb
'18
10:31 p.m.
Dear all,
given a table definition and (explained) SQL query as follows:
CREATE TABLE foo (x INT,y INT); INSERT INTO foo VALUES (3,1), (2,2), (1,3); ALTER TABLE foo SET READ ONLY; CREATE ORDERED INDEX foo_x ON foo(x);
EXPLAIN SELECT * FROM foo ORDER BY x;
In the EXPLAIN output, am I supposed to see that the order index is indeed used? I currently do see an algebra.sort operation, of course, but do not see any reference to the foo_x index. I had expected to find an bat.getorderidx operation in the MAL program.
Can anyone shed light on this? I'd be grateful.
Cheers,
—Torsten
--
| Prof. Dr. Torsten Grust
| Database Systems — Universität Tübingen (Germany)
| ✉︎ torsten.grust@uni-tuebingen.de
| db.inf.uni-tuebingen.de