Summary: March 23, 2008 Databases: DB Performance 1
DB Performance and Tuning
March 23, 2008 Databases: DB Performance 2
Objectives
Introduction +
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

Source: Adam, Salah - Department of Information and Computer Science, King Fahd University of Petroleum and Minerals

Collections: Computer Technologies and Information Sciences