Subject Re: [IB-Architect] order by not using index
Author Alexandre Kozlov
Hi ALL,

I just want to add that 'natural order' (or any other one) is much more
effective when we
explicitly get benefits from underlying software/hardware engine layer. In
this vision
it seemed 'read ahead' brings undoubtly great acceleration. I tested this
approach on very
large DB to speed up scannig operation drastically on main table.

Alexander Kozlov