SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Ian Stirk / Include usage of indexes on views? / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 18:08:19 GMT20RE: Include usage of indexes on views?http://www.sqlservercentral.com/Forums/Topic1341306-1358-1.aspxPlease ignore this topic.I am a newbie and I created a topic when I was trying to post a reply to a topic.Tue, 07 Aug 2012 08:36:13 GMTEddie KramerInclude usage of indexes on views?http://www.sqlservercentral.com/Forums/Topic1341306-1358-1.aspxSomething like:Change: INNER JOIN sys.tables st ON st.[object_id] = si.[object_id]To: INNER JOIN sys.objects st ON st.[object_id] = si.[object_id] AND st.type IN ('U','V')Your script will be of use to me. Thanks.Tue, 07 Aug 2012 08:29:52 GMTEddie Kramer