Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Descending Index Expand / Collapse
Author
Message
Posted Sunday, January 6, 2013 5:02 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 1:54 AM
Points: 108, Visits: 1,099
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?
Post #1403326
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse