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 -> Re: deletes and indexes

Re: deletes and indexes

From: <nomorekiss_at_yahoo.com>
Date: 27 Jan 2005 05:06:38 -0800
Message-ID: <1106831198.306794.279600@z14g2000cwz.googlegroups.com> 





Oracle has to update the index (remove deleted entries) + remove rows
from table.



If you only deleted small number of rows, the operation would be faster
because oracle would use index access to update referring blocks
instead of performing full table scan.
Received on Thu Jan 27 2005 - 07:06:38 CST












Original text of this message













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