How can you gather statistics on a table?

Question Posted / guest

Answers were Sorted based on User's Feedback

How can you gather statistics on a table?..

Answer / mkjmkumar

A. If u want to gather statistics with output use
Set Autotrace on
B. IF u want to gather statistics only Without Output user
Set Autotrace TraceOnly

Is This Answer Correct ?

2 Yes

0 No

How can you gather statistics on a table?..

Answer / mkjmkumar

Use
>set autotrace on

Is This Answer Correct ?

1 Yes

0 No

How can you gather statistics on a table?..

exec dbms_stats.gather_table_stat (owner, tablename);
or
analyze table xxx estimate statiistics;

Is This Answer Correct ?

0 Yes

0 No

More Oracle AllOther Interview Questions

how to write a query without using where? Example- select * from employee where empno=10 I need to write this query without where clause.

What is database schema?

Explain the difference between a hot backup and a cold backup and the benefits associated with each

Difference between transaction type and transaction sources. : oracle accounts receivable

Where in the Oracle directory tree structure are audit traces placed?

wht r the base tables & primary key for BOM& WIP modules

Is it possible to drop a column in a table which contains only one column? How?

how to replace not in with not exist?

Give two methods you could use to determine what DDL changes have been made.

What is difference b/w Credit memo and Adjustment in AR.

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

How would you go about generating an EXPLAIN plan?

For more Oracle AllOther Interview Questions Click Here