11.4.7 Deleting data stored in a multi-chunk table in a batch
To delete data stored in a multi-chunk table in a batch, execute the TRUNCATE TABLE statement.
For details about how to delete all rows in a base table by using the TRUNCATE TABLE statement, see 11.1.5 Deleting all rows from a base table.
- Note
-
-
If you execute the TRUNCATE TABLE statement, all chunks in a multi-chunk table are deleted. An empty chunk is then created.
-
All chunks for indexes that are defined in a multi-chunk table are also deleted.
-
If there is an archived chunk, the corresponding archive files are also deleted.
-