

Monitoring and Tuning Database Performance › Reducing I/O › Through Database Design
Through Database Design
Take into account the following database design considerations for reducing I/O:
- Adding sets, indexes, pointers, redundancy
- Changing set type, set (index) order for non-SQL defined databases
- Changing location (area) of record or index, index and/or set stored VIA (or clustered)
- Changing UNLINKED constraints to LINKED (SQL-defined databases) or repeating item (non-SQL defined databases)
- Splitting a record
Copyright © 2014 CA.
All rights reserved.
 
|
|