Currently, there are 7333689 rows in table 'D' with 'valid_application_flag' = Y.

This can increase in the future...

I am just concerned with this....

If we see the...

PW, Application_Key is the primary key on table 'D'. So it will have unique values. Will the new query make an issue now?

Hi OldHand, Thnx for the reply...

Do u mean to say to rewrite the query like this?

SELECT  A.julian_month,  B.month_year, C.lienholder, C.product_credit_type   AS Requested_Product_Credit_Type, C.Period            

FROM  A INNER JOIN B ON ...