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 |
How to pipe multiline string to isql?
What are pl/sql packages?
how many columns can be used for creating index? : Sql dba
what are the advantages of cursors than procedures?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
How to raise user-defined exception with custom sqlerrm ?
how can we find the select statement is indexed or not?
how to get enames with comma seperated values by deptwise on emp table?
What is the full form of sql?
describe mysql connection using mysql binary. : Sql dba
What is java sql package?
what are sequences
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)