1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

Why truncate is faster than delete?

Question Posted / ajay singh


Why truncate is faster than delete?..

Answer / Shilpi Agarwal

TRUNCATE TABLE is faster than DELETE because it performs a single operation, which is to reset the table's row count and reclaim space, rather than deleting each row one by one.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is a design view?

1 Answers  

What are the advantages of VIEW?

5 Answers  

Which is better cte or subquery?

1 Answers  

how to convert dates to character strings? : Sql dba

1 Answers  

Where is pl sql used?

1 Answers  

What is the difference between delete and truncate statement in sql?

1 Answers  

What is sql partition?

1 Answers  

What is pl sql commands?

1 Answers  

What is identity column in sql server?

1 Answers  

What is the difference between SQL table and the PLSQL table?

3 Answers   Mastek,

Do we need to rebuild index after truncate?

0 Answers  

How do you declare a user-defined exception?

1 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories