Subject Re: Garbage, was Re: [firebird-support] SubSelect problems
Author Ann W. Harrison
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.