Sometimes we may have performance issues and we want to check the Optimizer Statistics Preferences at the table level. let’s check out the queries for that How to check optimizer stats preferences at the table level set pages 200 lines 200col owner for a16col table_name for a32col preference_value for a50select owner, table_name, PREFERENCE_NAME, PREFERENCE_VALUEfrom dba_tab_stat_prefswhere […]

The post How to check Optimizer Statistics preferences at the table level appeared first on Techgoeasy.