Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Help with performance with a view

Re: Help with performance with a view

From: Mat <anon_at_riqc.ca>
Date: Fri, 10 Feb 2006 11:28:04 -0500
Message-ID: <oa3Hf.5084$J%6.349415@news20.bellglobal.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US