Home Forums Article Discussions Article Discussions by Author Discuss content posted by Ron Johnson Indexes, Indexes, Indexes RE: Indexes, Indexes, Indexes
Ognjen Kovacevic
SSC-Addicted
Points: 496
More actions
July 5, 2011 at 7:20 am
#1348260
I think it is better to put "s.database_id = db_id()" in join statement
... INNER JOIN SYS.INDEXES AS I ON I.[OBJECT_ID] = S.[OBJECT_ID] AND I.INDEX_ID = S.INDEX_ID and S.database_id = db_id()