InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Is The Difference Between Type 1 Index & Type 2 Index? |
|
Answer» TYPE 1 & TYPE 2 are specified when an INDEX is created on the table. TYPE 2 index is the OPTION which comes with DB2V4. With TYPE 2 index data can be retreived faster as only the data pages are locked and not the index pages. Hence TYPE 2 index is recommended. TYPE 1 & TYPE 2 are specified when an index is created on the table. TYPE 2 index is the option which comes with DB2V4. With TYPE 2 index data can be retreived faster as only the data pages are locked and not the index pages. Hence TYPE 2 index is recommended. |
|