Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

1085


what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2273


Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable

1090


Give two methods you could use to determine what DDL changes have been made.

6684


what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?

2166


8. Supporting AP, AR and GL?

2263


Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

1258


HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

2464


What is autocashrule set? : oracle accounts receivable

1292


How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?

2356


which one is currently in used software cmpanies.

2103


What is the difference between conversions and interfaces? : oracle accounts receivable

1120


I would like to study certification course in Data base adminidtrator then where would i go to study this course?

2142


What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable

1095


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?

2099