Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Query Optimization question
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. Received on Thu Jul 10 1997 - 00:00:00 CDT