Re: stupid question on FTS

From: Thomas Roach <>
Date: Fri, 24 Aug 2012 00:02:46 -0400
Message-Id: <>

How about describing the actual problem instead of a solution. What issue are you specifically facing? Can you show us your problem where the optimizer is picking a FTS when it shouldn't?


Sent from my iPhone

On Aug 23, 2012, at 8:34 PM, Vasu <> 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
> --

Received on Thu Aug 23 2012 - 23:02:46 CDT

Original text of this message