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


Please Help Members By Posting Answers For Below Questions

Is foreign key mandatory?

543


How do you explain an index?

775


What is record in pl sql?

583


What is sql dialect?

516


What is exit statement?

537






What are triggers and its uses?

580


write an sql query to find names of employee start with 'a'? : Sql dba

568


what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

483


What is structural independence and why is it important?

537


How do I make sql search faster?

543


What is clause?

598


How do you optimize a stored procedure in sql?

488


What is error ora-01000: maximum open cursors exceeded

594


What will you get by the cursor attribute sql%rowcount?

543


What are pl sql data types?

542