Distribution databases need to be administered and maintained like any other database, which includes indexes. Microsoft have used index hints in several stored procedures, which limits us slightly, but these indexes have worked well for me on a number of systems and continue to do so.
Phil Grayson 0 Minutes
Published by Phil Grayson
Data & Infrastructure Generalist @xTENLtd | Co-Founder @Aireforge | Volunteer @LeedsData, @DataAndGravy & @SQLBits | Friend of Redgate | Surfer, Biker, Boarder View all posts by Phil Grayson