Re: Query Optimization question

Ignatius Cristina Michelle wrote:

> Hi.
>
> What statistical information can Oracle draw upon to determine how
> many
> rows will be satisified by a query coondition of the form "column =
> value", for example, "department = 'D'" where "department" may or may
> not be an "indexed" column. Where is this statistical information
> stored
> and what is the mechanism for keeping it up-to-date.
>
> Thankx in advance.
> Ignatius.
> iggycoco_at_pacbell.net
>
> P.S. If possible please copy me when posting a reply.

  Check out the Analyze SQL command and the Cost Based Optimizer.

--
Rich Woods
Technical Field Support Specialist, Oracle Corporation, USA
The above statements and opinions are my own and do not
necessarily represent those of Oracle Corporation.