Help with index

SQL++
, ,
3

EE use (which chan use index aggregates. i.e indexer will only return group values).

CREATE INDEX adv_type ON `my-db`(`type`);
SELECT d.type
FROM `my-db` AS d
WHERE d.type IS VALUED
GROUP BY d.type;
1 Like