Any bottlenecks in the query plan which can be tuned

Ali 2013-10-14 16:14:38

Dan Holmes 2013-10-14 16:26:43
there are missing index suggestions. Did you try those? My initial reaction to the plan was indexes on table1 and that is what the missing index suggestion is for.
Ali 2013-10-14 16:36:01
No . Havent seen the suggestions on index creation .All operations are using index right ?
SQLkiwi 2013-10-25 04:23:14
Click on the SELECT icon and choose the option to display suggested indexes. There are multiple potential issues with the query though, and you will have to review the suggestions for suitability before deciding what to do. If you can provide a non-anonymized plan, we may be able to offer more specific suggestions. Note that 'using an index' does not mean the query is using the optimal index.
Aaron Bertrand 2013-10-25 13:52:39
It could also be using the right index but in the wrong way.