Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Include usage of indexes on views? Expand / Collapse
Author
Message
Posted Tuesday, August 7, 2012 8:29 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 20, 2014 9:37 AM
Points: 7, Visits: 100
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.
Post #1341306
Posted Tuesday, August 7, 2012 8:36 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 20, 2014 9:37 AM
Points: 7, Visits: 100
Please ignore this topic.

I am a newbie and I created a topic when I was trying to post a reply to a topic.
Post #1341314
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse