4 ms·For non-clustered indices, yes.by jpitz 11y agoFor non-clustered indices, yes.jeremysmyth 11y agoand if the order is not important. Reordering large numbers of rows can be a very expensive operation.