Answer Posted / guest
We can gather statistics on a table through>>
analyze table TABLE_NAME compute statistics , or
analyze table TABLE_NAME estimate statistics
Regards
Abhinav
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
what is ora 24313?what is the procedure to exclude that error?
What purpose does the model database server? : sql server DBA
what is logical system in sap basis
Where do you find the default index fill factor and how to change it? : sql server DBA
what is a crs resource?
How would you extract DDL of a table without using a GUI tool?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
how can you schedule a job in database?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
how to restore files with rman?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
Query processing is slow(eg select query)how will u solve that
What are the different types of database compression introduced in sql server 2008? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
How do you troubleshoot errors in a sql server agent job? : sql server DBA