Subject Re: [firebird-support] firebird 2,0 and index optimization
Author Ann W. Harrison
ibrahim bulut wrote:

> does optimizer scan all records for calculating the data and build all the
> view or optimizer scan only records that i want from it.

Slightly off topic, but the optimizer doesn't look at records - just the
table definitions, index definitions, cardinality, and selectivity. It
produces a plan that the execution engine runs.