Some follow up on what you mentioned Hugo.

After removing the top 30 and now by taking a look at the index seek operation on episode table.

The actual number of rows is almost exactly the same as estimated which was one of the things i couldn't understand why is happening even after updating statistics.

Off course you explained that in detail in your post.

Thanks again.

Nader