Re: Optimizer to scan free text

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 8 May 2007 09:32:42 -0700
Message-ID: <1178641962.580049.255790@y5g2000hsa.googlegroups.com>

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 -- Received on Tue May 08 2007 - 11:32:42 CDT