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 are the different ways you can create databases in sql server? : sql server DBA
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
how can you process messages in order asynchronously?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
what are the benefits of flashback feature?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
what do you understand by fine-grained auditing?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
What is dcl? : sql server DBA
What types of replication are supported in sql server? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
how can you enable flashback feature?
Explain about your sql server dba experience? : sql server DBA
what is asm?