Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Answer Posted / b.r.reddy

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

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is dcl? : sql server DBA

1323


suppose you want to audit specific activities on sensitive data. How can you achieve that?

1057


What is the importance of a recovery model? : sql server DBA

1083


Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

2350


Which autogrowth database setting is good? : sql server DBA

1242


how can you connect from 10g user to 11g user??

2166


Explain about your sql server dba experience? : sql server DBA

1160


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

1152


what is the use of ocr?

1075


What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

1093


How do you trace the traffic hitting a sql server? : sql server DBA

1634


What is a system database and what is a user database? : sql server DBA

1318


What is replication? : sql server DBA

1234


What is the difference between clustered and non-clustered index? : sql server DBA

1147


What are the operating modes in which database mirroring runs? : sql server DBA

1242