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]