Click here to Skip to main content
15,886,110 members
Articles / Database Development / SQL Server / SQL Server 2008
Tip/Trick

Index and Sort Order

Rate me:
Please Sign up or sign in to vote.
0.00/5 (No votes)
20 Jul 2012CPOL 7.9K   2  
What the effects of Ordering in Index

Introduction

When we write the SQL Query we frequently use the ORDER BY clause to get the output in definite order (Ascending or descending).

But ORDER BY clause has deep impacts in the performance of the query executions. In this article I am trying to discuss related to it. 

Read more... 

 

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Database Developer GAMUT INFOSYSTEMS LTD.
India India
JOYDEEP Das is working as a Sr. Software Engineer of an ERP based company. He has written many articles on the ‘MS-SQL SERVER’ on his blog at http://sqlknowledgebank.blogspot.in and http://sqlservernet.blogspot.in/, along with 10+ years of hands on experience as a software developer. He holds number of certifications, including 'MVP', 'MCDBA', 'MCSE', 'CAN' and 'ADSE'. He is also the active member of various group of www.linkedIn.com related to Database design and Architecture. He has worked on Database Architecture design, Database Development and Data ware houses with ‘Microsoft BI’. Feel free to comment/contact to Joydeep Das with related query on the articles given in his blog on his email id das.joydeep2@gmail.com

Comments and Discussions

 
-- There are no messages in this forum --