Re: Help with performance with a view

On Fri, 10 Feb 2006 10:40:19 -0500, Mat <anon_at_riqc.ca> wrote:

>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

Please clarify first why you think you 'need' to convert a string to a number, when that isn't the datatype of the column, and implicit conversion is almost always performed when receiving data by any client.

--
Sybrand Bakker, Senior Oracle DBA