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
d27m11yAsked:
Who is Participating?
 
slightwv (䄆 Netminder) Commented:
Are you adding an global index to a partitioned table?

I don't believe the specific table stats are affected.  Possibly if you specify "COMPUTE STATISTICS" on the crate index statement


It should be simple enough to test:
create a table.
compute statistics.
look at the last_analyzed column for the table
wait a minute or three.
add you index
look at the last_analyzed column for the table
0
 
d27m11yAuthor Commented:
when is analyze table compute statistics rebuild indexes used
0
 
slightwv (䄆 Netminder) Commented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.