how will u find statistics of a database objects?
Answers were Sorted based on User's Feedback
Answer / ramesh kotha
exex dbms_stats.gather_table_statistics
('<schema>','<tablename>');
| Is This Answer Correct ? | 1 Yes | 0 No |
What is the difference between the sql*loader and import utilities? : aql loader
How do I sort a table in sql?
What is a primary key, and how is it different from a unique key?
Can pl sql procedure have a return statement?
what is table? : Sql dba
What are pl/sql cursors?
what are the limitations of identity column? : Transact sql
if a string is there like s1,s2,s3,s4.How to find count of commas in this.
How to run sql statements through the web interface?
What is pls integer?
Why is sql*loader direct path so fast?
What is a self join ?
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)