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 |
what is semphore explian it?
HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?
How would you go about increasing the buffer cache hit ratio?
What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?
Explain about party and customer in ar : oracle accounts receivable
Explain prerequisites and post activities of oracle database installation
please send me oracle pl/sql exp resume. and also faqs...
How would you determine who has added a row to a table?
i am having comm in emp table and i want to display 0 when comm =null and -10 if comm= value
Explain the difference between a hot backup and a cold backup and the benefits associated with each
I have 3+ Years experience HR with Technical Recruitment Industry. Now i would like to learn oracle HRMS Models of all aspect. please suggest any one, which institution is best for oracle HRMS practical with real time teaching in Chennai, Tamilnadu. What are the basic stat up to learn Oracle HRMS with Core strongly?
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable