How can you gather statistics on a table?
- 3 Answers
- 7915 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 |
I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
What is chargeback invoice? How do we create it? : oracle accounts receivable
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
Explain the payment term in ar. : oracle accounts receivable
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me
Where would you look for errors from the database engine?
How do you add a data file to a tablespace?
A scenario for amount correction & how to use amount correction functionality in AP invoices
What does coalescing a tablespace do?
i have marks in table,how to find total?
Oracle General 
