K
Keith Sudbury
Guest
Depending on the data skew you could change the order of the index to EndNum,StartNum and get a more consistent number of records per query. In some cases this works great because you quickly find a record with just a few extra reads. In other cases it is just as bad or worse. Other solutions would be something similar to what Tim suggested. Or changing the design of the TT to store the data in a more index friendly way.
Continue reading...
Continue reading...