Piling on Luis's and Gail's posts, withholding or piecemeal'ing any relevant information is a waste of everybody's time! From the limited information supplied so far, one question arises, how are the indices and the statistics maintained? By the looks of it the statistics are stale, mind you that with out the full info this is just a wildcard guess, but seeing the estimate of 55 rows and actual number of rows roughly 1100 times greater is a hint.

😎