HI ALL,
BELOW QUERY TAKING TOO MUCH TEMPORARY TABLE SPACE AND IT GOING FOR FULL TABLE SCAN.SO IT TAKING MORE TIME TO EXECUTE.i WANT TO REWRITE THE QUERY..PLZZ HELP ME..
OS:WINDOWS SERVER 2003,VERSION:9.2.0.7