Home Forums SQL Server 2008 T-SQL (SS2K8) Troubleshooting\Tuning sql query taking more than 40 secs RE: Troubleshooting\Tuning sql query taking more than 40 secs

  • August 9, 2014 at 9:20 am

    #1736620

    You've mentioned to expect between 10 and 50 rows as the result set.

    However, the actual execution plan returned more than 280.000 rows.

    Are those rows really returned?

    Or is there usually a WHERE clause applied that you didn't use when runnning the query to get the actual execution plan?


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]