| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: TKPROF shows SELECT... LIKE '%ABC' uses INDEX RANGE SCAN - is that possible???
Jan wrote:
> How it is possible that Oracle was aible to response to the 2-nd
question
> SELECT * FROM t a1 WHERE name LIKE '%10'
>
> by using INDEX RANGE SCAN ?
Because it wasn't that exactly, it was
> SELECT * FROM t a1 WHERE name LIKE :x
Oracle has no idea what :x may contain at runtime, and has made some assumption that leads it to choose the index range scan. The index rang scan WILL work, it's just that it will have to start at the beginning and scan right through to the end. Received on Fri Oct 01 2004 - 06:23:25 CDT
 |
 |