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 the difference between dropping a database and taking a database offline? : sql server DBA
What are the operating modes in which database mirroring runs? : sql server DBA
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
What purpose does the model database server? : sql server DBA
who owns the operating system files created by the utl_file package?
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
How would you extract DDL of a table without using a GUI tool?
how can a session indicate its interest in receiving alerts?
How do you open a cluster administrator? : sql server DBA
how can you find out if a table can be redefined?
what is the use of ocr?
What is the importance of a recovery model? : sql server DBA
What happens on checkpoint? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
Why would you call update statistics? : sql server DBA
