This chapter introduces the basic concepts of database performance tuning, which is useful for large database. Upon completion of this chapter, you will have the following understanding:

1. Understand the concept of tuning.
2. Understand the concept of index.
3. Understand the types of indices and when each can be used.
4. Understand the basic procedure of SQL tuning.

 

Class Index

School of Technology
College of Business & Applied Sciences
Eastern Illinois University