| Subject | Select performance | 
|---|---|
| Author | Marek Konitz | 
| Post date | 2005-09-15T07:44:35Z | 
Hello,
I've checked performance analysis done by IBExpert and noticed curious
thing:
select * from TABLE
results in n non-indexed reads
select * from TABLE order by PRIMARY_KEY_FIELD
is n indexed reads.
Is there real performance difference?
[Non-text portions of this message have been removed]
            I've checked performance analysis done by IBExpert and noticed curious
thing:
select * from TABLE
results in n non-indexed reads
select * from TABLE order by PRIMARY_KEY_FIELD
is n indexed reads.
Is there real performance difference?
[Non-text portions of this message have been removed]