Hi all, I'm tring to optimize the following query:
http://rafb.net/paste/results/YdO9vM69.html
as you can see from the explain after defining the index the performance is worst.
If I raise the default_statistic_target to 200 then the performance are worst then before:
Without index: 1.140 ms With index: 1.400 ms With default_statistic_targer = 200: 1.800 ms
tought anyone ?
Regards Gaetano Mendola
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings