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.


Cheers,


Ann