Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


how will u find statistics of a database objects?

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

Post New Answer

More SQL PLSQL Interview Questions

wtite down triggr not any entry on Sunday

2 Answers   NIT,


what is data manipulation language? : Sql dba

0 Answers  


Explain raise_application_error.

0 Answers  


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

0 Answers  


How many functions are there in sql?

0 Answers  






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

0 Answers  


What are the uses of sysdate and user keywords?

0 Answers  


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

0 Answers  


What is the purpose of the sql select top clause?

0 Answers  


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

0 Answers  


What is row_number () in sql?

0 Answers  


how can we repair a mysql table? : Sql dba

0 Answers  






Categories