Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Analyze index after creation

Analyze index after creation

From: MGC <gconron_at_zdnetmail.com>
Date: 2000/05/01
Message-ID: <8ekl38$p7e$1@nnrp1.deja.com>#1/1 






Quick question - after creating indexes on a large table (50 million+
records), should you do an analyze on the table and all indexes or is
this an unnecessary step (assuming that the indexes are valid and
useful)?



Thanks,


Greg Conron




Sent via Deja.com http://www.deja.com/


Before you buy.
Received on Mon May 01 2000 - 00:00:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US