Why truncate is faster than delete?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

Where not exists in sql?

0 Answers  


What is the difference between unique and primary key constraints?

0 Answers  


In table three columns with 1 milion records(here there is no sequence values) i want add one more column with sequence values from the first how it is posible?

4 Answers   Tech Soft,


Does sql support programming?

0 Answers  


What is the Diff b/w Constraints and Trigeer

4 Answers   HCL,






Can a trigger call a stored procedure?

0 Answers  


Are stored procedures compiled?

0 Answers  


What is normalization ?

9 Answers   BirlaSoft, CTS, HCL,


What is the difference between DELETE, TRUNCATE, and DROP?

3 Answers  


What is trigger and stored procedure in sql?

0 Answers  


what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

0 Answers  


What is coalesce in sql?

0 Answers  


Categories