Interested to Buy Any Domain ? << Click Here >> for more details...
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
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?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
What are the different types of indexes available in sql server? : sql server DBA
what is the use of recording information about current session?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
how can you record information about current session?
how can you create a user-defined lock?
What is a system database and what is a user database? : sql server DBA
What are statistics, under what circumstances they go out of date, how do you update them?
what are the types of connection load-balancing?
what is a crs resource?
What is the difference between clustered and non-clustered index? : sql server DBA
