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
Is foreign key mandatory?
How do you explain an index?
What is record in pl sql?
What is sql dialect?
What is exit statement?
What are triggers and its uses?
write an sql query to find names of employee start with 'a'? : Sql dba
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
What is structural independence and why is it important?
How do I make sql search faster?
What is clause?
How do you optimize a stored procedure in sql?
What is error ora-01000: maximum open cursors exceeded
What will you get by the cursor attribute sql%rowcount?
What are pl sql data types?