Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Friday, November 4, 2016 2:37 AM
Points: 43, Visits: 217
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