How can you gather statistics on a table?

Answer Posted / kd

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

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is auto invoicing? : oracle accounts receivable

657


what are the tools used for oracle 10g in real time.

1929


What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable

714


Explain the payment term in ar. : oracle accounts receivable

617


Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?

2359






which gives Oracle R12 Financial training in delhi please give me answer its urgent?

1914


Is there any link between pr form(purchse requisition)and po form(purchase order)

2139


What is autocashrule set? : oracle accounts receivable

735


What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?

1594


What view would you use to determine free space in a tablespace?

1781


Differentiate between earned discounts and unearned discounts? : oracle accounts receivable

668


what are basic modules required to implement oracle application in any oraganisation?

1700


CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

1612


Difference between negative and positive adjustments : oracle accounts receivable

620


What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

3987