How can you gather statistics on a table?
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 |
Difference between negative and positive adjustments : oracle accounts receivable
What view would you use to determine free space in a tablespace?
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
deference between & and &&
How to find 8th person record in a table? Plz mail ur answers to mak2786@gmail.com Regards Arun
How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?
What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?
which one is currently in used software cmpanies.
I am working in Oracle Clinical 4.5.1 Please explain a bit.How to create Views in OC
Explain prerequisites and post activities of oracle database installation