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: Index Leafs don't empty on delete why pls help....

Re: Index Leafs don't empty on delete why pls help....

From: Carlos <miotromailcarlos_at_netscape.net>
Date: 12 May 2006 02:59:51 -0700
Message-ID: <1147427991.468594.157530@q12g2000cwa.googlegroups.com> 





Peter:


>>We have to rebuild it again and again if delete % is high...




Did you find performance issues or is it only a 'matter of size'?



Sybrand:


>>Other than that: yes eventuall you should rebuild.




And what about alter index ... coalesce?



Cheers.



Carlos.
Received on Fri May 12 2006 - 04:59:51 CDT












Original text of this message













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