Descending Index

• mah_j

  SSCrazy

  Points: 2931

  More actions

  January 6, 2013 at 5:02 am

  #272518

  Hi

  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?