--- In firebird-support@yahoogroups.com, Milan Tomeš - Position <tomes@...> wrote:

>
> Hi,
>
> no problem - I guessed it.
> This is pretty strange - did you checked that index is active (or "did
> ya tried to switch it off and on again" - means deactivate & activate
> that index) or another typo hiding us a word "DESC"? :-)
>

Nope. They are certainly active (IBExpert tells me so). I tried the active/inactive suggestion though. No effect.

This is not the only query with this problem - I have quite a few. Which is where I stuffed up - I was just cutting it down to the bare minimum to explain the problem - and cut it down too much! I actually do a join on another table, and that has the same problem - but that query takes 7 minutes to return these 30,000 records! This basic query (I think) shows the same problem though - non indexed reads.

This is on the same machine - ie the server is localhost. I run a very fast I7 machine with 12 gig ram, etc, etc. Processing/memory is not an issue. IBExpert also gives me these specs

------ Performance info ------
Prepare time = 0ms
Execute time = 610ms
Avg fetch time = 21.03 ms
Current memory = 28,629,984
Max memory = 92,409,076
Memory buffers = 3,000
Reads from disk to cache = 618
Writes from cache to disk = 0
Fetches from cache = 60,485

It seems all the reads are coming from cache...dunno if that is an issue or not?