none
execution plan suggestion request RRS feed

Answers

All replies

  • Hi,

    what exactly is your question ? Please provide more details.


    Sanil Mhatre | Database Developer | MCTS | If you find my reply useful in any way, please vote it as helpful. If it has helped answer your question, please mark it as Answer. http://sqlwithsanil.com

    Wednesday, July 24, 2013 2:39 AM
  • If possible post the complete plan.

    from the screen shot , the inference will Clustered index scan is taking place. Either your query is requesting bulk amount of rows or the predicate provided cannot make use of Clustered Index key.


    Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    Wednesday, July 24, 2013 5:01 AM
    Answerer
  • What you are showing is SQL Server scanning the clustered index  on UserActionLog table. So is it bad or good , I have no idea , please provide more info. How big is the table? How much rows does it return? Show us the query you are running.

    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Blog: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance

    Wednesday, July 24, 2013 5:15 AM
    Moderator