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

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

1223


How do you create a credit note against an invoice? : oracle accounts receivable

1139


What is the use of lockboxes? : oracle accounts receivable

1262


Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?

8008


Where in the Oracle directory tree structure are audit traces placed?

2694


Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

2305


Differentiate between transaction type and transaction source? : oracle accounts receivable

1154


difference of using cursor for loop and open,fetch,close.which one is better

1857


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

2286


What is an Oracle database Partial Backup?

1202


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?

2916


I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

2555


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

1190


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

2788


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

2374