What's the benefit of "dbms_stats" over "analyze"?

Question Posted / narmada kumari

What's the benefit of "dbms_stats" over "analyze"?..

We can manually set the statistical values.
We can gather statistics in parallel mode.

Is This Answer Correct ?

4 Yes

2 No

More DB Administration Interview Questions

How do you open a cluster administrator? : sql server DBA

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

How would you determine who has added a row to a table?

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

what is the use of recording information about current session?

How do you resize a data file?

Name a tablespace automatically created when you create a database.

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

What are the commands you'd issue to show the explain plan for "select * from dual"?

now one user in online.now i want drop him..how do u drop him?

Can you redefine a table online?

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

For more DB Administration Interview Questions Click Here