Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL tuning with LIKE expression
"Junaid" <letsconnect_at_hotmail.com> wrote in message
news:dfb44909.0309220843.1b38843a_at_posting.google.com...
> Hello,
> I'm using Oracle 8i and trying to tune a sql statement that has six
> table joins. I have a numeric indexed column which is using 'LIKE'
> expression in the where clause. This expression is causing full table
> scans for all the six joined table. Instead, if I substitute the like
> with = then the response is almost instataneous.
>
> For utility purposes, I have to use the like expression in the where
> clause. What are my other options to explore to tune the sql
> statement?
>
> I would appreciate any input.
If the data is a number then use appropriate numeric operators =, > between etc. If the data is text then store it as text in a character column and use text operators.
-- Niall Litchfield Oracle DBA Audit Commission UKReceived on Tue Sep 23 2003 - 04:25:36 CDT