Thanks again for the replies. I'm back from PTO and trying to tackle this problem once again.

In regards ROWSCANS or HASH, is that created on a view as well? I am actually reading for a view within Oracle that is populated by a package that runs on a schedule.

I'm thinking the MOD_DATE in the view might be my best best as a user should not be changing this field (or any field) in the view, only the package that runs.