Hi All,
I am worlking on application which generates 400,000 records per run and i use physical tables to store the temporary tables to hold the data which is used in manaipulation. th eproblem is after some runs the system gets slow down. I have some indexes on the temp tables as i join thme lots of times and i feel that those indexes are causing the problems.
I need suggestions and guidline for handling such large volume.
Regards,
AFfan