Hi All,
I would like to how does a truncate command behave in each of the database stages
DB2 Enterprise: Does it use the load and replace option to truncate data or does it do a delete from <table>. Also by default will this commands be captured in the redologs
Oracle Enterprise. Does it use the Truncate command or delete from <table>
Any inputs will be well appreciated.
Thanks,
Sai
Truncate in DB2 Enterprise and in Oracle Enterprise
Moderators: chulett, rschirm, roy
Since DB2 has no truncate, it will do a DELETE rather than the (more complex) load method to delete entries.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>