What is the difference between TYPE 1 index & TYPE 2 index
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 |
What is an instance in db2?
What is db2 and what is the use of db2 optimizer?
how to copy the host variables from ps file into cobol program other than include statement
PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?
2 Answers Tech Mahindra, Wipro,
I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.
How can you display the current date & current time ?
What is bind plan?
How could one combine a set of incremental image copies into a single copy?
What is DCLGEN ?
Mention some fields that are a part of sqlca.
if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records
How does DB2 use multiple table indexes?