Summary: March 23, 2008 Databases: DB Performance 1
DB Performance and Tuning
March 23, 2008 Databases: DB Performance 2
DB Performance +
Tuning Indexes +
Tuning the DB Design +
Tuning the Queries +
Tuning Views +
March 23, 2008 Databases: DB Performance 3
- Introduction ...
Every DB system is developed to fulfill the data
requirements of its users and application programs.
All the workload numbers used during the physical
design process are normally good estimates of the
expected actual numbers.
After a DB is deployed and is in operation, actual use
of the applications, transactions, queries, and view
reveals factors and problem areas that may not have