Hi all,
I'm tring to optimize the following query:


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 ?

Gaetano Mendola

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to