DB2 LUW Performance: Joe the DBA and the lost art of PCTFREE

Are you Joe the DBA? Or Jane? Do you have questions about DB2 LUW Performance? Would you like to learn about DB2 Performance in real-time? Join the studio audience for The DB2Night Show and get the latest tips, techniques, and answers to your questions --- like this question about PCTFREE that we recently received.

[ more.. ]


DB2 LUW Performance: Attend IDUG Europe in Rome!

Keep your skills sharp and your databases optimized - attend IDUG Europe in Rome to advance your career, learn the latest DB2 tips, tricks, and techniques, and improve your business performance. Visit the IDUG Europe web site for details! And be sure to sign up for my Ed Seminar "300 Fast Fabulous DB2 Facts and Performance Tips"!

[ more.. ]


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.. ]


Page :  1