Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: question for the wise?
"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 ?
>
What happens if you execute 1. multiple times? I believe you only see the 'hit' once. No?
-- Pablo Sanchez, High-Performance Database Engineering mailto:pablo_at_hpdbe.com http://www.hpdbe.com Available for short-term and long-term contractsReceived on Thu May 09 2002 - 17:00:51 CDT