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.