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 RANGE SCAN not used when View is used

Re: INDEX RANGE SCAN not used when View is used

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Wed, 17 Mar 2004 06:40:14 +0100
Message-ID: <g4pf501undmm98etc85cjlqjiri5sa167e@4ax.com> 





On 16 Mar 2004 15:08:39 -0800, readyjapan_at_hotmail.com (mcrn) wrote:



>However, there are two restricions that must be imposed to the

>solution:

>1) I am not allowed to use db hints.

>2) I cannot change the original sql query.




So you seem to be stuck. Your post also doesn't include the necessary
details to result in any sensible answer.



--
Sybrand Bakker, Senior Oracle DBA


Received on Tue Mar 16 2004 - 23:40:14 CST












Original text of this message













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