How can you gather statistics on a table?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / balu
exec dbms_stats.gather_table_stats('ownername','tablename')
| Is This Answer Correct ? | 4 Yes | 0 No |
What is the importance of a recovery model? : sql server DBA
Explain the use of setting GLOBAL_NAMES equal to TRUE.
Name two files used for network connection to a database.
what is ora 600?
If we issue alter database begin backup. What happens to database?
How to start SQL Server in minimal configuration mode?
What is the difference between clustered and non-clustered index? : sql server DBA
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
Give the reasoning behind using an index.
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What are the different types of database compression introduced in sql server 2008? : sql server DBA
How would you determine the time zone under which a database was operating?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)