TSQL: which type of real number leads to faster comparisons
2 answers
Are these relative comparisons>, <or equality comparisons = ,! =?
Floats and reals are approximation data types where there is an actual representation as a decimal number. If you're doing equality, you'll want to stay away from floats and reals. So this leaves decimal places.
Most likely SQL Server will not go to FPU for comparative comparisons. FPU and other coprocessors are used for arithmetic.
0
source to share