Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between delete and truncet ?
- 7 Answers
- 11446 Views
- Fidelity, I also Faced
- E-Mail Answers
Answer Posted / nitin bisht
Delete : A delete statement deletes the data from a table. A
delete statement can have a where clause, on which it
deletes the records that satisfy only the “where” condition.
If the
“where” condition is omitted the delete statement deletes
all the records in a table.
Actions of Delete statement :
* deletes the data from the current table space
* Modifies the undo tablespace with the delete records.
* Executes all the before / after statement and row
level triggers.
* Updates the indexes (makes the index empty if the
where clause is omitted).
* Constraint checks are performed before deleting the rows
.
Syntax of a delete Statement:
DELETE FROM table [WHERE condition]
Truncate : Truncate drops all the records in a table . But
as it is a DDL statement data cannot be retrieved. Usually
truncate is faster than delete statement becuase there is no
need to change or update the UNDO tablespace with the
deleted records. Truncate is an implict commit
Statement.Truncate statement deallocates the space.
Actions of Truncate Statement:Removes all the records from
the current tablespace.
* Updates the indexes.
* High watermark of the truncated table is reset.
* Integrity Constraint checks are performed
Syntax of a Truncate Statement:
TRUNCATE TABLE table_NAME ;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?
Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool
Is hive a database?
What is the difference between a stored procedure and a query?
Explain entity set?
Explain data independence & its types.
What do you mean by database?
sparse lookup and where its options we find in OCI and db2?
What are the tools used for backup and ticketing?
What is a database lookup?
Explain natural key?
List the properties of a transaction.
Define stored procedure?
What are the advantages of normalizing a database.
How to do Data integrity testing? Who does this testing (Developer or tester)?
