Popular Posts

  • SSMS is Free
    SQLServerCentral » Latest topics SSMS is Free Comments posted to this topic are about the item [B] SSMS is Free [/B] more info... ...
  • Adding to Lists
    SQLServerCentral » Latest topics Adding to Lists Comments posted to this topic are about the item [B] Adding to Lists [/B] more in...
  • The March of AI
    SQLServerCentral » Latest topics The March of AI Comments posted to this topic are about the item [B] The March of AI [/B] more in...

SQLblog.com - The SQL Server blog spot on the web

Loading...

Friday, December 1, 2017

How to resolve Multiple lookup operation in execution plan for same index

SQLServerCentral » Latest topics
How to resolve Multiple lookup operation in execution plan for same index
In a Query Block, We are using a table (CustomerOpenOrder) multiple time to join with other tables. In Execution plan, Lookup operation for that table is showing multiple times , attaching the complete query
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)