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 |
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
What are the steps you will take, if you are tasked with securing an SQL Server?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
internal architecture
What is blocking and how would you troubleshoot it?
what is incremental checkpoint?
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 are the different types of database compression introduced in sql server 2008? : sql server DBA
wat is global index and local indes
What is the dataguard background process??
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
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)