tag:blogger.com,1999:blog-210951494042177551.post6723440212270249706..comments2014-10-09T08:39:44.515-07:00Comments on Subbu's Tech blog: Indexes and Order by clauseSubramanya Phttp://www.blogger.com/profile/02145745782171776006noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-210951494042177551.post-87022486004261379102010-01-26T18:40:13.035-08:002010-01-26T18:40:13.035-08:00jagadish - There is no particular reason taking fo...jagadish - There is no particular reason taking for non clustered but most of the time we get this situation when using non clustered index only. <br />We use multiple indexes in many scenarios. I dont think it will decrease the performance. If you have a query which requires multiple indexes then definitely you can go for it. I will try to explain some situations when we need to go for multiple indexes.Subramanya Phttps://www.blogger.com/profile/02145745782171776006noreply@blogger.comtag:blogger.com,1999:blog-210951494042177551.post-13611949750891717092010-01-26T18:11:06.273-08:002010-01-26T18:11:06.273-08:00One question Subbu. Is there any particular reason...One question Subbu. Is there any particular reason for using Non-Clustered index in your example? <br />Also, the common known fact (I am not sure if I am correct here, please correct me if I am wrong) is that try avoiding multiple indexes on a single table because it potentially decreases the performace.Anonymoushttps://www.blogger.com/profile/11738392585030593273noreply@blogger.com