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 -> Storage parameter setting for indexes

Storage parameter setting for indexes

From: Randi Wølner <rw_at_computas.no>
Date: Thu, 02 Nov 2000 08:05:25 GMT
Message-ID: <9f9M5.1105$Pqb.180101632@news.telia.no> 






    
  
  1.   How important is it - for performance reasons - to have as few extents as
possible for indexes ?

  
  2.   I have read somewhere that for tables one should set pctincrease to 1
(instead of 0, as I would otherwise prefer)  - as otherwise coalesce would
not be done automatically. Is this true for indexes too?






Thanks in advance!



Best regards,


Randi Wølner
Received on Thu Nov 02 2000 - 02:05:25 CST












Original text of this message













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