global index - Table stats

Posted on 2014-03-06
Medium Priority
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
Question by:d27m11y
  • 2
LVL 78

Accepted Solution

slightwv (䄆 Netminder) earned 2000 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

Author Comment

ID: 39911356
when is analyze table compute statistics rebuild indexes used
LVL 78

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.

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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.

Join & Write a Comment

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

600 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