devxlogo

Discovering the Reason for Poor Query Performance

Discovering the Reason for Poor Query Performance

What can cause poor performance of a query? Any or a combination of these:

  • No indexes exist for the tables
  • Unnecessarily complicated joins
  • Excess usage of cursors
  • Excess usage of temporary tables
  • Stored procedures being recompiled excessively
  • Procedures or triggers without SET NOCOUNT ON

devx-admin

Share the Post: