Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: HELP: select ... like speed issues
"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
check out the CON*TEXT cartridge...it is designed for this kind of situation. Received on Tue Jun 08 1999 - 17:49:40 CDT