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

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