Kbase P117623: SQL: Hints on how to improve the performance of SQL queries?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/1/2009 |
|
Status: Verified
GOAL:
SQL: Hints on how to improve the performance of SQL queries?
GOAL:
What steps can be taken to optimize SQL queries?
GOAL:
Some actions and ways that make SQL queries run faster.
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
1. Run UPDATE STATISTICS regularly against the database.
2. Tune the database indexing periodically to make sure that it is aligned with the applications' requirements.
3. Remove unused indexes or add new ones to meet the applications' requirements.
4. Know the data and the number of records in each table to help write the query in its optimum form.
5. Write various forms of the query and examine the Query Plan of each variation of the query.
6. Try to get the query to start its data scanning from the smallest to the largest tables.
7. Include the query that yields the optimum performance during testing in the application.