HELP: select ... like speed issues

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 - 18:03:02 CDT