Re: ADVICE NEEDED - Striping? SQL? Speed

Each of the columns contains relevant data. No index, because they contain multiple words. The strings could be anywhere ('%') in each of the fields ('or') the strings could be spread across the three fields ('and'). Is there a more efficient way to put this query? Should I restructure the tables?

Ikro Yoon wrote in message <7i2eab$7ml_at_news.acns.nwu.edu>...
>Are you using index? One problem with yours, however, is that if the mask
>in the LIKE operator begins with a percent sign or an underscore character,
>the index cannot be used. Also in some cases, Oracle will not use an index
>if the condition in the WHERE clause contains the OR operator.
>Looking at your SQL statement below, I see three things that are slowing
>down your query.
Received on Thu May 20 1999 - 21:44:46 CDT