| INDEX ANALYZE [message #314007] |
Tue, 15 April 2008 08:50  |
lioracle
Messages: 68
Registered: February 2008
Location: Israel
|
Member |
|
|
hello
i need please script that do for me analyze for all my index in schema.
thanks
|
|
|
|
|
|
| Re: INDEX ANALYZE [message #314012 is a reply to message #314010] |
Tue, 15 April 2008 09:06  |
lioracle
Messages: 68
Registered: February 2008
Location: Israel
|
Member |
|
|
but if see the index i see BLEVEL HIGH AFTER DBMS_STATS
but if i run analyze index .... compute estimate
i see BLEVEL 2.
|
|
|
|
|
|
|
|
| Re: INDEX ANALYZE [message #314019 is a reply to message #314016] |
Tue, 15 April 2008 09:47 |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
It's not that I don't believe you, but could you show us some evidence (cut and paste from SQL*Plus) that shows the Blevel changing for an index as the result of an Analyze/Dbms_Stats command.
(And I don't mean changing from null to a value).
What version of Oracle are you using?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
