SQL Server's utilization of indexes and SARG operator Understanding _mssql

Source: Internet
Author: User
When writing SQL statements, many times you use filter to filter out some records, SQL to filter the criteria for short: SARG (search Argument/sarg)
Copy Code code as follows:

where amount>4000 and amount<6000 the above sentence is the filter condition

Of course, this isn't about SQL Server's WHERE clause, it's about SQL Server's use of indexes in SQL Server for expressions without the SARG operator, indexes are useless, and SQL Server is difficult for them to use the more optimized approach.

It means that if you don't have a WHERE clause in your SQL statement that includes a SARG operator, your SQL statement will not use the index in the table.

Let's say what are the non-SARG operators :
Non-SARG operators include
Not,
<>,
Not EXISTS,
Not in,
Not like
The rule is that there is a "not" keyword or not equal to the meaning of basically not using the index
There are also internal functions that SQL Server will not use if you use these internal functions
Internal functions, for example: CONVERT (), UPPER (), etc.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.