RE: Very slow request with many ORs in where parts

2003-02-11 Thread Andy Eastham
Artem, Have you considered using a full text index? I don't really understand exactly what you are trying to do, but consider it if you haven't already. Andy > -Original Message- > From: Artem Koutchine [mailto:[EMAIL PROTECTED]] > Sent: 11 February 2003 14:23 > To: [EMAIL PROTECTED] > S

RE: Very slow request with many ORs in where parts

2003-02-11 Thread Victor Pendleton
Can you post your explain plan? -Original Message- From: Artem Koutchine [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 11, 2003 8:23 AM To: [EMAIL PROTECTED] Subject: Very slow request with many ORs in where parts Hi! I have the following table: create table law_words ( l_id i