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: How to optimize for this?

Re: How to optimize for this?

From: Jörg Menker <jmenker_at_muenster.de>
Date: 12 May 2006 02:35:59 -0700
Message-ID: <1147426559.328889.238980@u72g2000cwu.googlegroups.com> 





> Creating an index on date doesnt feel worthy

> since 99,99% in each partition, or at least jobid, is the same.




Sounds if a bitmap index on the date column would be a good idea.



Regards,



Jörg
Received on Fri May 12 2006 - 04:35:59 CDT












Original text of this message













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