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

What is relationship? How many types of relationship are there?

1180

What does partition by mean in sql?

960

How many columns should be in an index?

963

what is the difference difference between procedure and packages

10405

Explain unique key in sql.

1012

What is integrity in sql?

1043

Why partition by is used in sql?

1038

How do I view tables in mysql?

984

What do you mean by field in sql?

1077

What is the difference between instead of trigger and after trigger?

1010

what is a database lock ? : Sql dba

1168

Which version of sql do I have?

1055

Explian rowid, rownum?

1012

What are sql ddl commands?

1090

What is sql used for?

1124