340 likes | 431 Vues
Learn how to optimize performance by using QUBE for index design and estimating CPU time for queries. Gain insights into B-Tree index anatomy and efficient access methods for common transactions.
E N D
Proactive Index Design using QUBECourtesy of Tapio Lahdenmäki Lauri Pietarinen Relational Consulting Session Code: F04 Nov 09, 2010 8:30 – 9:30 AM | Platform: z/OS, LUW
Q - Quick U - Upper B - Bound E - Estimate A simple formula for estimating CPU and elapsed time for queries, created by Tapio Lahdenmäki and others at IBM-Finland
Summary Qube is a way of thinking about indexes It can be used to prevent performance problems It can (and should) be used in conjunction with other tools It can be used to understand and analyze performance problems
Lauri PietarinenRelational Consultinglauri.pietarinen@relational-consulting.com F04 Proactive Index Design using QUBE