[WEBINAR] Application Acceleration: Faster Performance for End Users

SQL Performance

Definition - What does SQL Performance mean?

SQL performance is measured by how efficiently and quickly SQL queries are able to perform the required function. SQL performance can be measured by the time it takes to complete the operation and whether the output of the operation matches the expected requirements. SQL performance can drop below a certain standard due to various reasons, but there are ways to improve performance.

Techopedia explains SQL Performance

SQL can perform both simple and complex operations. An example of a simple operation can be retrieving the dates of birth of all employees in a certain department, while that of a complex operation can be retrieving the dates of birth of all employees in a large enterprise whose names end with the letter P, who have passport numbers starting with 54 and have traveled outside the United States in the last 15 years. The more complex the operation, the longer the amount time needed.

There are many ways to improve SQL performance, including:

  • Multiple joins in a single query should be avoided.
  • A set-based query should be used instead of a cursor-based query.
  • Non-correlated scalar sub-queries should be avoided in standard queries.
  • Multi-statement Table Valued Functions (TVFs) should be avoided as part of the query.
  • Indexes should be used as efficiently as possible.
  • The columns in an index should be positioned carefully.

Techopedia Deals

Connect with us

Techopedia on Linkedin
Techopedia on Linkedin
"Techopedia" on Twitter

Sign up for Techopedia's Free Newsletter!

Email Newsletter

Join thousands of others with our weekly newsletter

Free Whitepaper: The Path to Hybrid Cloud
Free Whitepaper: The Path to Hybrid Cloud:
The Path to Hybrid Cloud: Intelligent Bursting To Amazon Web Services & Microsoft Azure
Free E-Book: Public Cloud Guide
Free E-Book: Public Cloud Guide:
This white paper is for leaders of Operations, Engineering, or Infrastructure teams who are creating or executing an IT roadmap.
Free Tool: Virtual Health Monitor
Free Tool: Virtual Health Monitor:
Virtual Health Monitor is a free virtualization monitoring and reporting tool for VMware, Hyper-V, RHEV, and XenServer environments.
Free 30 Day Trial – Turbonomic
Free 30 Day Trial – Turbonomic:
Turbonomic delivers an autonomic platform where virtual and cloud environments self-manage in real-time to assure application performance.