Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between TYPE 1 index & TYPE 2 index
- 1 Answers
- 13290 Views
- IBM, I also Faced
- E-Mail Answers
Answer / s
TYPE 1 index has subpages and uses index locking.
TYPE 2 index has no subpages and does data-only locking.
| Is This Answer Correct ? | 20 Yes | 4 No |
When do you specify the isolation level? How?
What is runstats and reorg in db2?
What is the role of union all and union
What is a composite index and how does it differ from a multiple index?
How do you insert a record with a nullable column?
What is the physical storage length of the data types date, time, and timestamp?
how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...
What is null indicator in cobol db2?
What is the maximum number of tables that can be stored on a Partitioned Table Space ?
Is the primary key a clustered index?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
0 Answers ITC Infotech, Syntel,
What is a clustering index ?
COBOL 
