RE: CBO question ?
- From: "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>
- To: "'spinto@xxxxxxx'" <spinto@xxxxxxx>, "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Thu, 2 Mar 2006 11:38:54 -0500
If user/all/dba_tables.num_rows is not null, statistics for the table exist.
The last_analyzed column tells you when they were gathered.
Paul Baumgartel
paul.baumgartel@xxxxxxxxxxxxxxxxx
212.538.1143
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Savio Pinto (s)
Sent: Thursday, March 02, 2006 11:32 AM
To: paul.baumgartel@xxxxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: CBO question ?
Thanks, but how can i check/verify that the statistics are stored for a
particular table in the data dictionary ?
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Baumgartel, Paul
Sent: Thursday, March 02, 2006 9:31 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: CBO question ?
If any table mentioned in the query has statistics stored in the data
dictionary, Oracle will use the CBO.
Paul Baumgartel
paul.baumgartel@xxxxxxxxxxxxxxxxx
212.538.1143
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Savio Pinto (s)
Sent: Thursday, March 02, 2006 10:28 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: CBO question ?
Hi,
The execution plan for a query in oracle 9i shows "Optimizer= CHOOSE", how can
i force the DB engine to use the COST based optimization for a query ?
Oracle version is 9.2.0.4.0
Thanks
Savio Pinto
==============================================================================
Please access the attached hyperlink for an important electronic communications
disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================
==============================================================================
Please access the attached hyperlink for an important electronic communications
disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================
Other related posts:
