Change your index so that it is indexing on (START, TYPE)
That way, things that just need an index on START can use it as well. On 2015-06-04 10:16 AM, Rinse Lemstra wrote:
The query below takes about 5 sconds to run select uren.MEDEW_ID as MEDEW_ID, uren.START as UREN_WEEK, sum(uren.DUUR) as DUUR from uren as uren where uren.START >= '2015-05-25' and uren.START < '2015-06-01' and *uren.type = 0* group by uren.MEDEW_ID, UREN_WEEK When I remove the *uren.type = 0* where clause, the query runs in a few miliseconds. When I EXPLAIN the query I see it uses the index on the field TYPE, when I remove the *uren.type = 0*, the query uses the index on START. Also, when I remove the index on the field TYPE the query runs fast.
-- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
