Hai,
Can i do a Analyze compute statistics on sys tables...?
Will it increase my performance...?
...Thomas
Printable View
Hai,
Can i do a Analyze compute statistics on sys tables...?
Will it increase my performance...?
...Thomas
NO NO NO NO NO!!!!
BY NO MEANS ANALYZE YOUR SYSTEM TABLES!!!!!!
For all the advantages that Oracle touts about using the cost based optimizer, they still require the use of the rule based optimizer on their own tables. If you analyze Oracle's tables they will tell you to delete all the statistics on their tables before they will support you.
Joe
Thanks a lot.....
..thomas
*chuckle* Your welcome :)
Just wanted to emphasize that you shouldn't do this *laugh*