> [!DataFileTruncate] > <table><tr><td rowspan="4" width="25%"><img src="assets/wl_io_datafiletruncate.png"></td><td><b>Wait Category</b></td><td>IO</td></tr><tr><td><b>Mechanism</b></td><td><code>DataFile</code></td></tr><tr><td><b>Operations</b></td><td><a href="Operations/Table/SeqScan">SeqScan</a></td></tr><tr><td><b>Resources</b></td><td><a href="Resources/disk IO">disk IO</a>, <a href="Resources/CPU">CPU</a></td></tr><tr><td colspan="3"><b>Physical Space Reclamation Barrier</b>. Unlike a simple <code>DELETE</code> (which leaves the file size unchanged), a truncation physically removes the pages from the end of the file and returns that space to the filesystem.</td></tr></table>