Improving the performance of the procedure that fetches huge amount of data
626489Mar 4 2008 — edited Mar 4 2008I have procedure which functions something like this.There is a base search query .The result of the base query is inserted into temp_sql table.And then we filter out the data from the temp_sql on the basis of some condition and we put this data under different section in another temp swl table.Can Anyone suggest me a better solution for this entire operation.Thanks and Regards.