Re: Optimizer to scan free text

On May 8, 11:55 am, Norcale <nilaybha..._at_gmail.com> wrote:
> 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- Hide quoted text -
>
> - Show quoted text -

An explain plan pertains to more than queries with joins; it can explain much in how the optimizer 'sees' your query with respect to your data. In the absence of the query text and the associated explain plan attempting to diagnose this problem is difficult, at best, as most suggestions will be guesswork.

I would suggest you post your query, the table structure, any indexes you may have on this table and the explain plan, as you'll receive much more useful help.

David Fitzjarrell Received on Tue May 08 2007 - 12:26:20 CDT