Return to Answer

ORDER BY NEWID()

takes 7.4 milliseconds

WHERE num_value >= RAND() * (SELECT MAX(num_value) FROM table)

takes 0.0065 milliseconds!!!

I will definitely go with later method.

ORDER BY NEWID()

takes 7.4 milliseconds

WHERE num_value >= RAND() * (SELECT MAX(num_value) FROM table)

takes 0.0065 milliseconds!

I will definitely go with latter method.

ORDER BY NEWID()
taking 7.4 milliseconds

WHERE num_value >= RAND() * (SELECT MAX(num_value) FROM table)
taking 0.0065 milliseconds!!!

I will definitely go with later method.

ORDER BY NEWID()

takes 7.4 milliseconds

WHERE num_value >= RAND() * (SELECT MAX(num_value) FROM table)

takes 0.0065 milliseconds!!!

I will definitely go with later method.

ORDER BY NEWID() taking 7.4 milliseconds

WHERE num_value >= RAND() * (SELECT MAX(num_value) FROM table) taking 0.0065 milliseconds!!!

I will definitely go with later method.

ORDER BY NEWID()
taking 7.4 milliseconds

WHERE num_value >= RAND() * (SELECT MAX(num_value) FROM table)
taking 0.0065 milliseconds!!!

I will definitely go with later method.