i see analyze statistics on local temp table is supported in document.
will the statistic data purged while close the session which create the temp table?
the temp table is about 1M rows, created in a job whih called 1000 times a day. and data in the temp table is not static.
+1You need to use ON COMMIT PRESERVE ROWS option while creating the TEMP table. If the data is getting lost while you come out of the session, stats will also be lost.
+1Hi,
The stats are only avilable in the running session for the local temp tbl.
To see the stats status use this query:
select projection_schema,anchor_table_name,projection_name,has_statistics
from projections where anchor_table_name='temp_tbl_name';
If you drop the tbl / close the session no data will be returned by the statistics query.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
