Re: Optimizer to scan free text

From: Norcale <nilaybhagat_at_gmail.com>
Date: 8 May 2007 09:55:27 -0700
Message-ID: <1178643327.271526.52750@e65g2000hsc.googlegroups.com>

On May 8, 11:32 am, Mark D Powell <Mark.Pow..._at_eds.com> wrote:
> On May 8, 11:47 am, Norcale <nilaybha..._at_gmail.com> wrote:
>
> > I am trying to scan a field that has free text. The problem is that
> > the database is huge and it takes hours for the query to come back. I
> > am running a simple query with a like condition. Any ideas as to what
> > optimizer I could use to save some time?
>
> > Thanks
>
> What version and edition of Oracle?
>
> If you have EE (Enterprise Edition) have you considered the Context
> option which provides text indexing and search capabilities.
>
> For that matter is the column in question indexed? Where is the
> explain plan?
>
> HTH -- Mark D Powell --

I am using Oracle 9i and the column is not indexed. I do not have an explain plan for it, but I am only querying one table so there is no issues with joins here.

Thanks Received on Tue May 08 2007 - 11:55:27 CDT