Subject | Re: [firebird-support] Where is the time does ??? |
---|---|
Author | Doug Chamberlin |
Post date | 2007-09-05T19:22:51Z |
At 03:02 PM 9/5/2007, Ann W. Harrison wrote:
is not always faster than natural access in storage order (despite the
magic that what some people attribute to indexing).
>The time went into retrieving the data in index order rather thanTo amplify on that and state the implication explicitly: access via indexes
>in storage order. Dropping the index or altering the query so the
>index can not be used may improve the query performance by allowing
>Firebird to access the data in storage order.
is not always faster than natural access in storage order (despite the
magic that what some people attribute to indexing).