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 are two statement types in sql?
What is composite data type in pl sql?
How to sort the rows in sql.
What are sql triggers used for?
What is auto increment in sql?
What is the most restrictive isolation level? : Transact sql
What is pivot query?
How do I run a sql query?
What is a merge query?
How to run sql functions in pl/sql?
what are all different types of collation sensitivity? : Sql dba
What is Referential Integrity?
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)