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

Can you index a snaphot of a report ( for use with a filter) Expand / Collapse
Author
Message
Posted Friday, March 8, 2013 4:45 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 3, 2014 3:40 AM
Points: 40, Visits: 143
Once you have snapshotted as report & it is maintained in the reportserver database, is it possible to index a snaphot?

I'm thinking this might be beneficial when using filtering against large snapshots.

Or another way of looking at it. What performance criteria does a filter use when the filter is used against a snapshot?

Thanks



Post #1428518
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse