questions - Question:Why use Truncate over Delete while deleting all rows ?

  1. Truncate is efficient. Triggers are not fired.
  2. - It deallocates space (Unless REUSE STORAGE is given).

asked Sep 13, 2013 in ORACLE by anonymous
edited Sep 12, 2013
0 votes

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.