|
View previous topic :: View next topic
|
| Author |
Message |
arock08
New User
Joined: 15 Apr 2005
Posts: 4
|
|
|
|
| What is TYPE 1 INDEX and What is TYPE 2 INDEX? What are the differences betweeen these two indexes? |
|
| Back to top |
|
 |
vijayamadhuri
Active User
Joined: 06 Apr 2005
Posts: 180
|
|
|
|
just found this info if it could be helpful
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. |
|
| Back to top |
|
|
|
|
