External Table And Temporary table upper limit
Will there be a preformance degradation when the number of records in an external table is very huge? Will the select hang ? etc , or can external table handle any amount of data?
Similarly can the Global temporary table handle any amount of data? with preserve rows? or do we have to size the temporary tablespace accordingly ?
Please guide if anyone has come across these types of scenarios.
Last edited by Rohit; 02-16-2005 at 06:09 AM.
Success Consists of Getting Up Just One More Time Than You've Fallen Down