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: What index access path does INDEX_SS yield ?

Re: What index access path does INDEX_SS yield ?

From: Spendius <spendius_at_muchomail.com>
Date: 4 Jan 2007 03:07:04 -0800
Message-ID: <1167908823.841971.158290@51g2000cwl.googlegroups.com> 





> However, thinking further about this piece of trace file,

> it looks to me as if Oracle hasn't see your hint at all.

> This suggests that there is a syntax error somewhere

> in your hint.



I don't think so as the optimizer reacts to my hint, it
reacts the wrong way but does react anyway: when
I remove the hint I get an FTS on TABLE_1.
Received on Thu Jan 04 2007 - 05:07:04 CST












Original text of this message













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