whats going wrong here – query taking too much time to return result
2014-07-07 22:58:40
2014-07-08 01:47:37
You can speed it up some if you add the outputs from the Key Lookup to table1.index6.
Also, I would take a look at the nested join with no predicate (the one with the x)…not a time hog, but just makes the plan look ugly. 🙂