jasajona wrote:

>
> Now I can reproduce that situation, when that query and all others
> that is using these tables is getting so slow. I have procedure in my
> app where I delete many (~14000) records from 3 tables, run select
> query and post results (also 14000 records).

What indexes do you have on those three tables? What is the selectivity
of those indexes - use gstat to check.


Regards,


Ann