Subject Re: [firebird-support] Where is the time does ???
Author Doug Chamberlin
At 03:02 PM 9/5/2007, Ann W. Harrison wrote:
>The time went into retrieving the data in index order rather than
>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.

To amplify on that and state the implication explicitly: access via indexes
is not always faster than natural access in storage order (despite the
magic that what some people attribute to indexing).