Rohit Jadhav wrote:so we avoid making recommendations that you deem unworkable, tell us now what you are willing to do to improve performance.
I understand your points, but since it is huge application is built over a period of time. I am afraid if i will be allowed to do change on datatypes.
I have to manage in current situation. Not expecting query to respond in millisecs but not even 40secs which is happening currently.
Your temp table uses VARCHAR2 and a length longer than the source. That doesn't make much sense.
COD_ACCT_TITLE CHAR(192), -- defined in source table COD_ACCT_TITLE VARCHAR2(360), -- defined in temp table