ctrl wrote:
> I have news...good news for me:)
> even though I wasn't able to find the answers I was looking for, I did
> something that made a big difference: by removing the ORDER BY clause,
> the same function takes now 5 milliseconds (instead of sometimes 10
> minutes).
> I have tried to vacuum, analyze, etc...nothing worked.
> I post this hoping it could help somebody.
How many memory are you using for the sort operations, is that column
indexed ?
Regards
Gaetano Mendola