Index on a Precision Field (Lap Time)

Feb 2, 2013 at 3:28 AM
What is the best approach to keep an index on a precision field? We keep large telemetry databases of lap times, car, tracks, etc..

It seems off to me to have a double precision floating point lap time value indexed by integer, yet I don't want to have to load the sub collections (many thousands of individual telemetry samples that make up a lap) in order to display lap time.

Am I looking at the problem incorrectly?