| Statistics about a Schema,Database [message #56024] |
Mon, 03 March 2003 04:58  |
Mukesh Raj Singh
Messages: 9
Registered: March 2003
|
Junior Member |
|
|
Sir,
Tell me how to collect statistics about a schema, about a database.Does computing statistics changes the optimizer mode?
How to look for the Optimizer mode if it is not mentioned in Parameter file?
rgds
Mukesh
|
|
|
|
| Re: Statistics about a Schema,Database [message #56040 is a reply to message #56024] |
Mon, 03 March 2003 11:31  |
ctg
Messages: 146
Registered: July 2002
|
Senior Member |
|
|
How to find optimizer mode (default is CHOOSE)
SQL> show parameter optimizer_mode
or
SQL> SELECT value
2> FROM v$parameter
3> WHERE name = 'optimizer_mode';
If optimizer_mode=CHOOSE, then when statistics exist on a table, oracle will use cost based optimizer when referencing that table. if there are no statistics, then oracle will used rules based optimizer.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
