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?
views:
225answers:
1
+5
A:
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.
Tomalak
2010-01-11 10:38:01
Adding to that, floats take more storage space, so the index for floats should take more space thus being slower than indexes for ints.
Jonas Lincoln
2010-01-11 10:52:43