how will u find statistics of a database objects?
Answer Posted / ramesh kotha
exex dbms_stats.gather_table_statistics
('<schema>','<tablename>');
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to Declare Fixed Length String Value In PL SQL
Why is sql*loader direct path so fast?
Explain about various levels of constraint.
how to calculate the difference between two dates? : Sql dba
What are pl/sql cursor exceptions?
Which are the different case manipulation functions in sql?
what are the authentication modes in sql server? : Sql dba
What is oracle sql developer?
What is difference between cursor and trigger?
what is “go” in t-sql? : Transact sql
What is the need of merge statement?
What sql does db2 use?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
What is a delimiter in sas?
how to select unique records from a table? : Sql dba