When it comes to creating composite indexes there are two questions I get asked most often by the ISVs I work with as well as their customers. 1. What is the optimal number of columns to include in a composite index? 2. What should the order of those
Read More...