|
|
|
|
|
by henrikschroder
4501 days 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; |
|