Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / balu
exec dbms_stats.gather_table_stats('ownername','tablename')
| Is This Answer Correct ? | 4 Yes | 0 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
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
What purpose does the model database server? : sql server DBA
What the different components in replication and what is their use? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
How to start SQL Server in minimal configuration mode?
What is the difference between clustered and non-clustered index? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What is dcl? : sql server DBA
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
what is the role of dip user in our database?
What are the recovery models for a database? : sql server DBA
how can a session indicate its interest in receiving alerts?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
how can you communicate with operating system files from oracle?
