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 / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count

17779


how to replace not in with not exist?

3798


What is the importance of batch source set up in ar? : oracle accounts receivable

1318


I need a Technical evaluation between Oracle and SAP ? please do a need ful.

2037


Explain prerequisites and post activities of oracle database installation

2180


What do you mean by hz_ in customer tables? : oracle accounts receivable

1296


what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable

1169


we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.

2587


key flexfield structure

2233


Are These Dff's Flexible?

1209


Explain the use of table functions.

2573


default triggers available for reports

2264


what is difference between inner join & nested query or subqueries

3109


What is the difference between recovery and restoring of the oracle database?

1291


what is semphore explian it?

2879