GATHER STATISTICS FOR A SPECIFIC TABLE  AND SPECIFIC USER TO ENHANCE PERFORMANCE OF RUNNING SQL QUERIES :


>>  EXECUTE DBMS_STATS.GATHER_TABLE_STATS('SCHEMA_NAME', 'TABLE_NAME',estimate_percent => dbms_stats.auto_sample_size)