Use bind variables for one thing. Otherwise in either event you are going
to use up a lot of CPU resource etc.
Jim
"FC" <flavio_at_tin.it> wrote in message
news:wiAC8.42357$zW3.473798_at_news1.tin.it...
> Hi folks,
> here is a very simple question concerning good programming practice versus
> performance.
> I hope it will open up one of those neverending debates I like so much.
>
> 1.
> ===========================
> Select a,b,c from my_table
> where d = my_own_constants.XYZ
>
> say it takes 2 seconds.
>
>
> 2.
> ===========================
> Select a,b,c from my_table
> where d = 'XYZ'
>
> say it takes 1.5 seconds.
>
>
> my_own_constants is a bodyless package specification where I list all the
> constant values I need that might change in the future.
>
> Question:
> how can I increase the performance of solution 1 which is clearly easier
to
> maintain but 25% slower in performance than solution 2 ?
>
> Thank you
> Flavio
>
>
>
Received on Thu May 09 2002 - 20:29:11 CDT
