Quote:
Originally posted by ashley75
Does anyone encounter the problem with DBMS_STAT??? When we use this packages, the CBO fails to user indexes on large tables, it also errors when you try to compute statistics on the tables that had check constraints. It's only worked if you run estimate on 50% or less.
Your query may not be using the index on a large table because that is not the "best" plan according to the statistics. I am not aware of any bugs with dbms_stats and check constraints. Maybe if you post the exact errors.?.?.?