External Table And Temporary table upper limit
Hi Guys,
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.
Thankyou
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
Be Blessed