I get data in seconds without the top operator. I will check out the blog. Its really frustating as i have tried rewriting it different ways, I updated stats with full scan changed the clustered index on the coverage table. I cant seem to get rid of the nested loops. Any help is appreciated.