2 ms·
What are you talking about? According to that page, the example from the quiz would result in a tight index scan: > The GROUP BY does not begin with the first
by henrikschroder 13y ago
What are you talking about? According to that page, the example from the quiz would result in a tight index scan:
> The GROUP BY does not begin with the first part of the key, but there is a condition that provides a constant for that part:
> SELECT c1, c2, c3 FROM t1 WHERE c1 = 'a' GROUP BY c2, c3;