Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help with performance with a view
I've solved my problem!
No need to help me :)
Mat a écrit :
> 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 - 10:28:04 CST