Given statistics can be held on both:
A) When does the base GTT acquire derived, sample and full statistics on its columns.
Further, given user A and user B have an instance of the same GTT running in a query.
----------- session 1
INSERT INTO b_gtt SELECT a FROM t2;
COLLECT STATISTICS USING SAMPLE ON b_gtt COLUMN (a);
---------- session 2
INSERT INTO b_gtt SELECT a FROM t3;
B) will session 2's b_gtt use base table stats of t1, sample stats from t2 or derived stats from t3?
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.