Given the following query...SELECT CourseCatID, CategoryName FROM dbo.CourseCategories WHERE ParentCatID = 1 AND CourseCatID <> 1 AND ClientID = 1 ORDER BY CategoryName ASC
Should I have three separate indexes for each item in the where clause (ParentCatID, CourseCatID, ClientID) or should I have one index comprised of all three columns? And if they are separate do I include CourseCatID and CategoryName as include columns?