Include usage of indexes on views?

• Eddie Kramer

  Valued Member

  Points: 55

  More actions

  August 7, 2012 at 8:29 am

  #264786

  Something 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.

• Eddie Kramer

  Valued Member

  Points: 55

  More actions

  August 7, 2012 at 8:36 am

  #1522640

  Please ignore this topic.

  I am a newbie and I created a topic when I was trying to post a reply to a topic.