Re: HELP: select ... like speed issues

Hi Victor,

If your condition is "where yourfield like '%somestring%', as far as I know, a full table scan is inevitable.

To tune a full table scan action, you can: tune pctfree and pctused of the table,
distribute physical storage among multiple disk controlers and use parallel query,
increase database block size,
increase db_buffer in sga,
... (any others?)

Hth
bjin

OnlineJobStore.com wrote:

> Hi everyone,
>
> Here's the deal:
> - Oracle 8 running on NT box;
> - there is a table that contains around 100,000 rows;
> - each row contains a field (VARCHAR2) with 3000-4000 characters of
> text;
> - it is needed to run LIKE query against the field
>
> So far, the straightforward approach does not give satisfactory results
> and does not scale well either. Any ideas about it? Please do not
> mention "upgrade hardware" solution :)
>
> Thank you for help,
> Victor Urvantsev
Received on Wed Jun 02 1999 - 20:46:13 CDT