Re: Index_stats

From: <CHUCK_HAMILTON_at_qvc.com>
Date: Mon, 1 May 2000 12:21:56 -0400
Message-Id: <10484.104559@fatcity.com>

Nope. You need to do it index by index then insert the contents of INDEX_STATS into another table.
--

Chuck Hamilton
QVC Inc.
Enterprise Technical Services
Oracle DBA

                                                                                                                        
                    "Klavers, Richard"                                                                                  
                    <R.Klavers_at_arbeids        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>       
                    bureau.nl>                cc:     (bcc: CHUCK HAMILTON/QVC)                                         
                    Ext: NA                   Subject:     Index_stats                                                  
                    Sent by:                                                                                            
                    root_at_fatcity.com                                                                                    
                                                                                                                        
                                                                                                                        
                    05/01/00 11:37 AM                                                                                   
                    Please respond to                                                                                   
                    ORACLE-L                                                                                            
                                                                                                                        
                                                                                                                        

Hi list,

I am analyzing my indexes (analyze index ... validate structure) to find the
one's with a low percentage of pct_used. However, when i am done analyzing, i only see the last analyzed index in the
table sys.index_stats.
This is the table with the column pct_used that i need. Is there another table where i can find all the indexes? Or is there another
way to accomplish this task?
Thanx in advance,

kind regards, Richard Klavers.

--

Author: Klavers, Richard
  INET: R.Klavers_at_arbeidsbureau.nl

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon May 01 2000 - 11:21:56 CDT