Interested to Buy Any Domain ? << Click Here >> for more details...
How can you gather statistics on a table?
- 3 Answers
- 8797 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / kd
exec dbms_stats.gather_table_stat (owner, tablename);
or
analyze table xxx estimate statiistics;
| Is This Answer Correct ? | 0 Yes | 0 No |
what is the difference between TRUNCATE and DELETE command in SQL
23 Answers ICICI, Saama Tech, SkyTech, TCS,
what is the link between suppliers and banks in ap module in oracle apps? And also query?
as a technical developer in oracle applications which type errors feced in your experience sofar
When a user process fails, what background process cleans up after it?
What is the difference between the SQL*Loader and IMPORT utilities?
difference of using cursor for loop and open,fetch,close.which one is better
Explain the use of table functions.
where the dff data will be stored
please explain about oracle
What is the use of lockboxes? : oracle accounts receivable
Explain an ORA-01555
How can you rebuild an index?
Oracle General 
