Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: HELP: select ... like speed issues

Re: HELP: select ... like speed issues

From: Chris Markle <chris.markle_at_level3.com>
Date: Tue, 08 Jun 1999 16:49:40 -0600
Message-ID: <375D9E04.B4C4606D@level3.com>


"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US