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: Is there a way to speed up Index Fast Full Scan

Re: Is there a way to speed up Index Fast Full Scan

From: Gints Plivna <gints.plivna_at_gmail.com>
Date: 30 Sep 2006 13:12:04 -0700
Message-ID: <1159647123.938195.130930@k70g2000cwa.googlegroups.com> 





> I do not have access to source code. so I cannot rewrite queries,




As you cannot alter source code, probably you can check why range scan
isn't used and think whether some other index will be useful for range
scan not forgetting of course that another index will slow down DML .



Gints Plivna


http://www.gplivna.eu
Received on Sat Sep 30 2006 - 15:12:04 CDT












Original text of this message













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