Popular Posts

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

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

No comments: