İlke

I added the index the slow query obviously needs and nothing changed - how do you find out why it is not being used?

A query filtering on a couple of columns takes about two seconds on a table with a few million rows. I added an index covering those columns and the timing did not move at all. The index exists. I can see it in the…