whats going wrong here – query taking too much time to return result

Rsys dba 2014-07-07 22:58:40

Edward Norris 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. 🙂