It is possible to truncate a table and a snapshot in an Master-Snapshot architecture.
We must do that because the High Water Mark increases all the time thus a
select count(1) take a too long time to retrieve
0 rows selected.
Printable View
It is possible to truncate a table and a snapshot in an Master-Snapshot architecture.
We must do that because the High Water Mark increases all the time thus a
select count(1) take a too long time to retrieve
0 rows selected.
TRUNCATE is a DDL statement. It won't propogate to Snapshot.