Sorting Float Column vs Int Column in SQL Server

performance, sql, sql-order-by, sql-server-2008

Solution

For columns without an index on them, sorting does depend on the data type.

Floats are more complex than integers, so it is logical to conclude that sorting them takes a bit longer.

Problem

I wonder if type of a column matters in terms of sorting performance. I have heard that `int` columns are sorted faster than `float` columns. Do you think it is correct?

Original source