Include usage of indexes on views?

  • Eddie Kramer

    SSC Rookie

    Points: 45

    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

    SSC Rookie

    Points: 45

    Please ignore this topic.

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

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply