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 -> Question about Oracle Indexes

Question about Oracle Indexes

From: waltervdv <marcus.kuehl_at_t-online.de>
Date: 5 Nov 2001 06:06:01 -0800
Message-ID: <b2677297.0111050606.24d5f3f5@posting.google.com>


Hallo !

Is it true that Oracle (8i) does not remove dependent index-entries when a row in a table is deleted and that the only way to remove entries in an index is to rebuild the index ("alter index xyz rebuild")?  

Thanks ,

Marcus Received on Mon Nov 05 2001 - 08:06:01 CST

Original text of this message

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