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

What is meant by <> in sql?

510


What are all ddl commands?

551


Is trigger a stored procedure?

508


What is constant in pl sql?

519


difference between anonymous blocks and sub-programs.

625






How to run sql statements with oracle sql developer?

625


Can we use insert statement in function?

516


What is the best sql course?

534


How do you take the union of two tables in sql?

517


What is the main reason behind using an index?

557


what is a composite primary key ? : Sql dba

583


What is the best free sql database?

572


What are primary key and foreign key and how they work?

556


What is a pragma statement?

722


What is %s in sql?

569