Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: index vs fts

Re: index vs fts

From: <krish.hariharan_at_quasardb.com>
Date: Fri, 16 Nov 2007 13:18:43 -0800 (PST)
Message-ID: <14675.209.244.4.106.1195247923.squirrel@webmail.quasardb.com> 





I am not as familiar with using hints on views but hints should be
referencing table alias (JOB2, JOB3, etc). It may still not be honoured
because of the views.



You may still have to tackle the issue of determining what the bottleneck
is and optimize that as opposed to a full scan on this table.



-Krish




--



http://www.freelists.org/webpage/oracle-l
Received on Fri Nov 16 2007 - 15:18:43 CST












Original text of this message













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