d27m11y d27m11y
asked on
global index - Table stats
When you happen index to table that has global index, what happens to table stats.. do we have to analyze the table
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Analyze table is deprecated and really shouldn't be used any more.
The DBMS_STATS package is the new way of doing things.
Anyway, the online documentation will tell you what all is performed with the various options the commands offer.
Again, set up a quick test and see the commands in action.
The DBMS_STATS package is the new way of doing things.
Anyway, the online documentation will tell you what all is performed with the various options the commands offer.
Again, set up a quick test and see the commands in action.
ASKER