Which is faster delete or truncate?
- 1 Answers
- 1216 Views
- I also Faced
- E-Mail Answers
Answer / Ankit Bhatnagar
"Truncate" operation is generally faster than a "DELETE" operation because it quickly removes all rows from a table, without actually writing any deletion logic to the database log. Deleting data row by row takes longer as each row must be individually removed and logged.
| Is This Answer Correct ? | 0 Yes | 0 No |
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is dbrm? When it will be created?
How do you define a correlated name?
How does cobol compile db2 program?
How can you classify the locks in db2?
What is the use of db2 optimizer?
When reorg is used?
I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?
Is it mandatory to use DCLGEN? If not, why would you use it at all?
What is the cobol picture clause of the db2 data types date, time, timestamp?
Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.
How to find primary key of a table in db2?
COBOL 
