Restriction: This topic applies to Windows environments only.
The database administrator determines if the performance of a database is satisfactory for the application environment. Some factors that influence database performance include:
- Indexes
- Optimizing the structure of SQL statements
- Locking (in multiuser versions)
- Clustering
- Database design
- Caching
- Storage organization, including use of storage groups (stogroups)
