Subject RE: [IB-Architect] Disk Bandwidth was License Question
Author Claudio Valderrama C.
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.

Claudio Valderrama C.
Ingeniero en Informática - Consultor independiente

> -----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.