Subject | Re: [IB-Architect] order by not using index |
---|---|
Author | Alexandre Kozlov |
Post date | 2001-09-19T13:26:43Z |
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
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