Skip to content

Instantly share code, notes, and snippets.

@shaik2many

shaik2many/oracle-tablestats.sql

Created May 7, 2014 16:59
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save shaik2many/44a5276fd4369f680d09 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save shaik2many/44a5276fd4369f680d09 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
oracle-tablestats.sql
exec dbms_stats.gather_table_stats (ownname => 'abcDBA01',tabname => 't_table_name',estimate_percent=> 100,cascade => true);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment