Team with the best
Db2® LUW Performance Tools
company in the World

DB2 LUW Performance: Clustering Indexes

We just completed our Webinar on DB2 LUW Index Design Best Practices and Case Studies. Clustering Indexes were discussed, and one of the Webinar participants sent an email asking this question:

Great webinar today, thank you. A quick question on clustering indexes. When trying to determine the best columns by looking at the highest aggregate sort time, what should one do if there is already a cluster index on the table? That is, what to do if the existing cluster index is suspected to not be the right one? Here's my answer...

[ more .. ]

by Scott in DB2 Performance How-To
Page :  1