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:

• with myField as a varchar2, with an index on it select to_number(myField);

Any suggestion would be greatly appreciated.

Thanks,

Mathieu Received on Fri Feb 10 2006 - 09:40:19 CST