gtt taking very long - same thing in table runs fast why?
907388Dec 4 2012 — edited Dec 7 2012Hi All,
I have a report which is based off GTT. The reason we went for GTT is that process for each region can happen in parallel and users can run multiple reports. But it seems like when there is GTT report takes time (just this, other reports with GTT are running fine).
Once we CONVERT gtt to actual tables, it is running in less than five minutes.
Is there a liimitation with GTT not being able to process very large data or reading through large record set over 15 million?
Since processes can happen in parrallel, if GTT will not work can we use dynamic tables that are dropped and recreated each time? If the report uses dynamic sql - can we create one table for EACH session/
I know reporting tbale is the long term option but for now we would like to go with dynamic tables or gtt.
Regards