I have a DB2 table with over 22 million records. The table is BY FISCAL DATE
from 1999 to now. There's about 1 million rows per YEAR(FISCAL DATE).

The current selection is:

if YEAR(FISC_DATE) = 2010
AND ADATE <= '2010-07-07'


the proposed coding is plus ADATE is made index:
write new sql to retrieve the earliest ADATE for YEAR(FISC_DATE) = 2010
and pass it in @ED to next sql

if YEAR(FISC_DATE) = 2010
AND ADATE between '@ED and 2010-07-07'

WILL THIS PROPOSED CHANGE HELP PERFORMANCE?

Thanks, Don






where AC is acceptance_date

What columns do you have indexes on?

Andy

fisc_date and acceptance_date

Instead of use
Lenny

I think when you use a function index is not used. So Lenny is right.
But fiscal year is not necessaraly from Jan 1 to Dec 31 so the statement
IF FISC_DATE between '2010-01-01' and '2010-12-31' might not work.

Or if fiscal year end Jan 1 - Dec 31 you do not need to use FISC_DATE in your query so can do it this way:

No he meant that you replace it with this:
Andy

you mean:

Yes, that is what I meant.

Andy