Home Forums Reporting Services Reporting Services 2005 Administration SSRS 2005 Report Executions times RE: SSRS 2005 Report Executions times

  • August 31, 2012 at 12:47 pm

    #1532607

    Thanks. Appreciate the hint.

    I did a profiler and got the showplan xml files.

    Yes indeed. In SSMS there is a Clustered Index scan( 28%) , where as in SSRS execution , it is using a non-clustered index and there is a key lookup loop that is 46% cost.

    How to force it to scan the clustered index ?