C# Corner
Tech
News
Videos
Forums
Jobs
Books
Events
More
Interviews
Live
Learn
Training
Career
Members
Blogs
Challenges
Certification
Contribute
Article
Blog
Video
Ebook
Interview Question
Collapse
Feed
Dashboard
Wallet
Learn
Achievements
Network
Refer
Rewards
SharpGPT
Premium
Contribute
Article
Blog
Video
Ebook
Interview Question
Register
Login
.NET
ADO.NET
Android
ASP.NET
C#
Databases & DBA
Design Patterns & Practices
iOS
Java
OOP/OOD
SharePoint
Software Testing
Web Development
WPF
View All
5
Reply
Which one is faster delete/truncate? Why?
sakshi goyal
13y
4.3k
0
Reply
Delete Row
Delete Column
Insert Link
×
Insert
Cancel
Embed YouTube Video
×
Width (%)
Height (%)
Insert
Cancel
Table Options
×
Rows
Columns
First row as header
Create Table
Insert Image
×
Selected file:
Alignment
Left
Center
Right
Select an image from your device to upload
Upload to Server
Cancel
Submit
Truncante is performs better than delete because when you delete the records from the database, database has to perform 2 actions.1.delete from the database2.write the deleted records into "rollback" segments.But incase of "Truncate" the second activity is not required.
Ritesh Singh
9y
0
Truncate is faster Because when we use DELETE, all data get copied into the ROLLBACK TABLESPACE first, then delete operation get performed. This is opposite as truncate so truncate is faster
Rahul Prajapat
10y
0
Truncate is faster Because when we use DELETE, all data get copied into the ROLLBACK TABLESPACE first, then delete operation get performed. This is opposite as truncate so truncate is faster
Rupesh Kahane
11y
0
Truncate is faster because it delete data at a time.
Munesh Sharma
11y
0
Truncate is faster than delete as Delete has to perform two step's at database level for deleting but truncate has only one step.
Parin Turakhia
13y
0
When we give select * from emp; how does Oracle respond?
What is the difference between snapshot & materialized view ?
Message