Optimizer and Estimated Rows

Hi,

Wanted to understand, on how to make optimizer estimate the correct number of rows. I was running the below query, and even if the actual number of rows are changed the estimated number of rows doesnt changed.

I had tried creating the histogram / including the dynamic sampling hint, but still the estimated rows didnt change. This query uses the Adaptive cursor Sharing, even though multiple cursors are being generated, the estimated rows is not changing,

select /*+ gather_plan_statistics WILSON */ * from perform_return_fact
where perform_subject_id = :b1;

PLAN_TABLE_OUTPUT

SQL_ID  cyprrr8c4xk2r, child number 0