Which is faster delete or truncate?
No Answer is Posted For this Question
Be the First to Post Answer
What is a clustered index?
What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?
how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE
Why select is not preferred in embedded sql programs?
What is ALTER ?
What is Reorg Recovery? when will you run it?
When the like statement is used?
What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?
I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?
What can the Locate option of the Repair Utility accomplish?
What is dbrm? When it will be created?
What is the significance of DB2 free space and what parameters control it?