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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Index rebuild

Re: Index rebuild

From: Satish Narasimha <satishn_at_blr.sni.de>
Date: 1998/02/20
Message-ID: <34ED9C3A.F2880777@blr.sni.de>#1/1 







  Hello,



    I read in one of the article that if you want to have index rebuilt we need
not use


   Alter index.....REBUILD, instead if we execute select count(*) from <tabname>
will


   rebuild the index.



   Can anybody clarify how exactly this works.....



from


Satish. N.
Received on Fri Feb 20 1998 - 00:00:00 CST












Original text of this message













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