1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Post New Answer

More SQL PLSQL Interview Questions

what is pragma ?

1 Answers   Polaris,

how to include comments in sql statements? : Sql dba

0 Answers  

Hi Everyone, How to get fist and last record from a table in oracle? Thanks in advance

13 Answers   IBM,

I Defined SP1, Sp2 (sp=StoreProcedures)In Package Specification but I Implemented Sp1, sp2, sp3, sp4, sp5 then What type of Error You will find????

3 Answers   Infosys,

How to create an array in pl/sql?

0 Answers  




how to retrieve only duplicate values in a table

9 Answers  

What are the different ways to optimize a sql query?

0 Answers  

Are stored procedures compiled?

0 Answers  

What is pivot in sql?

0 Answers  

How will you delete a particular row from a Table?

7 Answers   Cap Gemini,

What is attribute indicator in pl sql?

0 Answers  

What is data manipulation language?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories