SQL tuning with LIKE expression

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.

Thanks
Junaid Received on Mon Sep 22 2003 - 11:43:22 CDT