Re: stupid question on FTS

From: Vasu <vasudevanr_at_gmail.com>
Date: Thu, 23 Aug 2012 20:11:51 -0500
Message-ID: <CA+O6cL+CFzARUhSn1maudrMM0Mb=XtTNqyyzQM+y4ZiPxbRJdw_at_mail.gmail.com>

Its on 11.2.0.3 , and being tested in load-test env. Thanks
On Thu, Aug 23, 2012 at 7:34 PM, Vasu <vasudevanr_at_gmail.com> wrote:

> I have a huge table in my OLTP DB, that has 100 million+ rows (pls don't
> ask why), and is partitioned.
>
> I know it doesn't make sense for my App to ever do a FTS on it.. But
> Oracle at times picks up FTS as the best access path (and our STATS is not
> at it best yet).
>
> It just wished for a setting..that "I never want to have a FTS on my
> table..Unless otherwise explicitly told thru a Hint" .
>
> yes, a Hint/setting can't compensate for lack of STATS.. but just that my
> desparate situation/laziness forced me to think that way.
>
> Any thoughts?
>
> Thanks,
> Vasu
>
>

-- 
-Vasu


--
http://www.freelists.org/webpage/oracle-l

Received on Thu Aug 23 2012 - 20:11:51 CDT