Create Index Desc order


  • Hi All,

    We have a large table over 500 million rows which has a createdate column defaulted to getdate(). 

    Over 95% of the queries use createdate to query for data created within last six months to an year.

    I am planning to create an index on createdate column in descending order rather than ascending.

    Is this a good use case scenario for creating index in descending order? 


    Tuesday, May 15, 2018 8:42 PM


All replies