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?