InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 14:45:20 GMT20http://www.sqlservercentral.com/Forums/Topic1403326-391-1.aspxHi I want to create an index for a table(340G).The data is required in descending order,and I have read that if I use ascending index,it can be scanned in backward direction,but it can not use parallelism .Furthermore descending indexes tend to become fragmented quickly.I don't know :1_Is parallelism useful?2_Does descending index lead to low performance in insert statement?Sun, 06 Jan 2013 05:02:52 GMTmah_j