Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between TRUNCATE and DELETE command
in SQL
- 23 Answers
- 67154 Views
- ICICI, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / dhanasekar.s
Truncate command executes faster then Delete command.
when you truncate the table we can't get back the data again
because data is removed from the memory.because ddl command
is auto commit.So we need not store any information about
deleted data in the memory.So it takes less time so faster.
But in the case of delete command is dml command.we can get
back(rollback) the data again.When you delete the data that
deleted data are stored in some where in memory that
information should be logged in the database log
information.From that information we can get the data again
easily.
So that (logging purpose) it takes time then truncate command.
It is my observation and my idea.If it is having any
mistakes please post the reason .
Thanks in Advance.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable
What is auto invoicing? : oracle accounts receivable
What is the difference between recovery and restoring of the oracle database?
what are the API of GL,PO,AP
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
What is chargeback invoice? How do we create it? : oracle accounts receivable
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
Are These Dff's Flexible?
Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?
How many segment are present in Oracle Manufacturing
