Hi, I am using temp tables to replace some inner queries to speed up the performance. The table in inner query has around 12 lakh records. Will it be better to create temp table and then insert all the huge records then ftech from temporary table. Even when I am selecting some records from that big table its taking 1 minute and 10 seconds.The inner query is as below : SELECT R.RTCODE,Q.FIX,Q.CLCALLNO,Q.CLACTCD,Q.CLCUSTCD,Q.CLCUSTBRCD,Q.CLOFFCD,Q.COMPCODE, Q.CLGENDATE,Q.CLCUSTCUSTCD FROM CLEXEC Q INNER JOIN MROUTE R ON Q.RTCODE=R.RTCODE AND Q.COMPCODE=R.COMPCODE AND Q.CLOFFCD=R.OFFCODE The table 'CLEXEC' has 12 lakh records and table 'MROUTE' has 1300 records. Please advice.