Visual Database Optimization

1
Visual Database Optimization
10 Nov, 2006

• Team
• Clint Johnson,
• Sunpreet Jassal,
• Thanh Nguyen-Huynh
• Masamichi Sugihara.

2
Databases Optimization

• Optimize database?
• Indexes
• Queries
• User objectives Identify
• Table indexes, size, structure
• Queries execute time, indexes

3
Progress - Tables
4
Progress - Queries
5
Progress Table property
6
Filter Name________________ Index type
Queries________________ Time
________________ Size ________________
Name Table 1 Table 2 Table 3 Table 4 Table 5
Index type
Queries 100 80 20 90 50
Time (ms) 2.00 1.20 0.20 1.40 1.00
Size 1000 800 200 900 500
Table property
Name Table 1 Indexes Columns Column 1,
Column2, Column 3
7
Progress put it all together