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 are the types of join and explain each? : Sql dba

0 Answers  

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

0 Answers  

How do you take the union of two tables in sql?

0 Answers  

I need a exceptoin in pl/sql block so that if any errors occur in the block then no exception should errors should raise?

1 Answers  

What operating systems are supported by oracle sql developer?

0 Answers  




What type of join is sql join?

0 Answers  

How many types of normalization are there?

0 Answers  

Do view contain data?

6 Answers   Ramco,

What is scalar function in sql?

0 Answers  

What is ROWID?

8 Answers  

what is view? : Sql dba

0 Answers  

What is full join?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories