question for the wise?

From: FC <flavio_at_tin.it>
Date: Thu, 09 May 2002 19:42:20 GMT
Message-ID: <wiAC8.42357$zW3.473798@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 - 14:42:20 CDT