Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Help with performance with a view
Hi,
I have a performance problem with a view. I need to convert a string field to a number field in the select statement of the view. But when I do this, the index on the table seems to be ignored, which is problematic with the response speed.
Is there any way to speed up the operation?
In perticular, here's my select:
Any suggestion would be greatly appreciated.
Thanks,
Mathieu Received on Fri Feb 10 2006 - 09:40:19 CST