ASA SQL User's Guide Monitoring and Improving Performance
Proper selection of indexes can make a large performance difference. Creating and managing indexes is described in Working with indexes.