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

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

2016


what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2223


What are different types of receipt reversals ? Explain them : oracle accounts receivable

1198


how to replace not in with not exist?

3661


Explain the process of recievables in oracle financials. : oracle accounts receivable

1107


What is db_recovery_file_dest in oracle? When do you need to set this value?

1078


Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

7571


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

2150


What is the use of lockboxes? Steps for lock box : oracle accounts receivable

1312


Explain the use of table functions.

2382


IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

2208


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

1067


My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.

2145


What is the mandatory setup in cyclecount ?

2698


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

17496