Header Ads

  • Recent Posts

    Updating Table Stats in Oracle

    To gather statistics in Oracle for a specific table use the following sql. One would need sysadm access to run this sql.
    Exec dbms_Stats.gather_table_Stats(‘SYSADM’,'TABLENAME');

    To know more about gathering statistics check out this Oracle link

    No comments

    Please refrain for marketing messages and unnecessary back links.

    Post Top Ad

    Post Bottom Ad