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