Speaking about optimizations and indexes, Jim, can you write a bit about
indexes and the query optimizer, please? There has been some controversy on
how Interbase takes into account indexes to generate optimum query plans.
Thanks.

C.
---------
Claudio Valderrama C.
Ingeniero en Informática - Consultor independiente
http://members.xoom.com/cvalde

> -----Original Message-----
> From: Jim Starkey [mailto:jas@...]
>
> Interbase indexes stores record number in the index; index retrievals
> return a structure called a sparse bitmap. Interbase traverses all
> indexes (not must primary ones) in bitmap order, which is physical
> order on disk, minimizing page reads by maximizing cache hits. This
> strategy always wins.