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

Why we use join in sql?

914

What are types of exception?

873

What is sqlerrm?

881

Can we alter stored procedure?

940

Do ddl statements need commit?

921

What is a data definition language?

1024

How does pl sql work?

911

How do I upgrade sql?

946

What are the types of optimization?

886

What is the syntax and use of the coalesce function?

1094

What is not in sql?

898

What are the different datatypes available in PL/SQL?

1026

what is the difference between myisam static and myisam dynamic? : Sql dba

1001

what is schema? : Sql dba

985

Is mariadb nosql?

988