exex dbms_stats.gather_table_statistics ('<schema>','

how will u find statistics of a database objects?

Question Posted / ramesh kotha

Answer Posted / ramesh kotha

exex dbms_stats.gather_table_statistics
('<schema>','<tablename>');

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do temporal tables work?

692

What is sql dialect?

741

What is set serveroutput on in pl sql?

811

What are %type and %rowtype for?

808

How can we solve sql error: ora-00904: invalid identifier?

885

how to dump a table to a file with 'mysqldump'? : Sql dba

739

What is mutating trigger?

768

How do I start sql profiler?

746

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

871

How do I find sql profiler?

683

How do I find duplicates in the same column?

733

What is varray in pl sql?

762

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

842

What is pls integer?

779

How do I remove all records from a table?

769