adspace


define clustering index.

Answer Posted / Sandip Kumar Tiwari

A clustering index in DB2 organizes the table data based on the value of one or more columns. This type of index can significantly improve performance for queries that frequently filter, sort, or join data using the clustered columns.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

2122


have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1809


What is the latest version of ibm db2?

1372