Any bottlenecks in the query plan which can be tuned
2013-10-14 16:14:38
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 ?
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.
2013-10-25 13:52:39
It could also be using the right index but in the wrong way.