Wednesday, March 27, 2013

Oracle inline view and global temporary table

Tom indicates that global temporary table is not used to improve the performance, it can only be used to use as the interface table. While in the real case, it's not true. Insert into two dates data into GTT and then calculate based on the GTT only needs 5 seconds. Inline view option needs 299 seconds.

No comments:

Post a Comment