Solved

global index - Table stats

Posted on 2014-03-06
3
548 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
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 with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

717 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