how will u find statistics of a database objects?

Question Posted / pgnath

Answers were Sorted based on User's Feedback

how will u find statistics of a database objects? ..

Answer / ramesh kotha

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

Is This Answer Correct ?

1 Yes

0 No

how will u find statistics of a database objects? ..

Answer / senthil vinayagam

Using analyze command

Is This Answer Correct ?

2 Yes

2 No

More SQL PLSQL Interview Questions

wtite down triggr not any entry on Sunday

what is data manipulation language? : Sql dba

Explain raise_application_error.

What are the popular database management systems in the it industry?

How many functions are there in sql?

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

What are the uses of sysdate and user keywords?

how can I make a script that can be bi-language (supports english, german)? : Sql dba

What is the purpose of the sql select top clause?

Why plvtab is considered as the easiest way to access the pl/sql table?

What is row_number () in sql?

how can we repair a mysql table? : Sql dba

For more SQL PLSQL Interview Questions Click Here