Hacker News Reader

For queries returning results from a majority of rows in the table, won't a sequential table scan be faster than an index scan?

For non-clustered indices, yes.

and if the order is not important. Reordering large numbers of rows can be a very expensive operation.