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 vs. partitioning for performance

Re: Index vs. partitioning for performance

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: 21 Apr 2006 02:27:08 -0700
Message-ID: <1145611628.841727.22140@z34g2000cwc.googlegroups.com> 





I'd say query performance could increase (the range to be scanned is
smaller), insert performance would be worse (more indexes to maintain).



Rebuilding indexes is always an issue, and the need (rather: no need)
has been discussed numerous times here. Why would you?



If the interger is derived from a sequence, a reverse index might help.



As alwyas: test and measure!
Received on Fri Apr 21 2006 - 04:27:08 CDT












Original text of this message













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