Solved

global index - Table stats

Posted on 2014-03-06
3
539 Views
Last Modified: 2014-04-08
When you happen index to table that has global index, what happens to table stats.. do we have to analyze the table
0
Comment
Question by:d27m11y
  • 2
3 Comments
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 39911304
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
 

Author Comment

by:d27m11y
ID: 39911356
when is analyze table compute statistics rebuild indexes used
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39911368
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

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question