Article : The Less SQL Server Sorts, the Faster It Responds

Learn coding techniques to tweak your SQL queries so that SQL Server sorts less data and returns much faster.


To read the full article click here

That was a nice article but in Technique 1: When you use a subquery expect that it will add more job for the DBMS to work on and you know that, so basically this would cause a much slower time processing on the data. Remember that the DBMS will start processing from the lower level query(subquery) statement going to the highest(parent Query) and these may cause a much more slower processing time additional to the burden is the usage of a functions such as sum(...), as much as possible if you want to make the performance of your database to be more faster then make the query simple, if possible only minimize the use of functions and I agree on the idea that we should be only accessing those needed field for the retrieval of information.

About sorting; when we use a field we should decide whether we'll be indexing it or not depending on the data sparsity that it has that is the purpose why there is indexing in the attributes that a data may have to minimize the burden when sorting it.

[Guest]

[44.197]

Yahoo crawler, adsense, Baidu Spider, Msnbot