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
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
what is the use of recording information about current session?
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.
who owns the operating system files created by the utl_file package?
How to start SQL Server in minimal configuration mode?
What the different components in replication and what is their use? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
how can you connect from 10g user to 11g user??
how can a session indicate its interest in receiving alerts?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
when does an alert gets signaled?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is the importance of a recovery model? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
