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
What is dcl? : sql server DBA
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What is the importance of a recovery model? : sql server DBA
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
Which autogrowth database setting is good? : sql server DBA
how can you connect from 10g user to 11g user??
Explain about your sql server dba experience? : sql server DBA
How do you open a cluster administrator? : sql server DBA
what is the use of ocr?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
What is a system database and what is a user database? : sql server DBA
What is replication? : sql server DBA
What is the difference between clustered and non-clustered index? : sql server DBA
What are the operating modes in which database mirroring runs? : sql server DBA