Meysam
Reputation: 18137
Sorting Float Column vs Int Column in SQL Server
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?
Upvotes: 3
Views: 2553
Answers (1)
Tomalak
Reputation: 338158
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.
Upvotes: 7
Related Questions
- SQL Server Sort varchar columns depend on numbers inside like int and decimal
- SQL Server - float vs varchar
- MySql sorting float data type
- sort float numbers as a natural numbers in SQL Server
- SQL query - Order by in the SQL query OR Sort a List<>
- SQL Order by a float column not working
- Is there a speed difference in ordering by int vs. float?
- Sql 2005, is it faster to sort by datetime or by int?
- SQL 2005 performance: column order when mixing varchars with int types
- Do Real Values sort different than floats in SQL Server queries?