IT Job search

SQL Server: Order of Operators

Something which may seem basic, but in many SQL statements I analyse for performance optimisation, the same mistakes are recurring. When a WHERE clause is used the actual operator used will influence the query speed. That is not to say , every statement has the option of using the optimal operator. It's worth keeping in mind the order of the operator , the order starts with the fastest performer. = <,<=,>,>= LIKE <>

Digg This : Click to email a colleague Author details ------------------------------------------------------------------------ Jack Vamvas is a SQL Server Consultant. To contact him about this article , or any issues related to SQL Server register on www.ciquery.com and post a question. For SQL Server Consultancy of any SQL Server task - check SQL Server Specialists Make SQL Server go faster - click here