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 will u find statistics of a database objects?

Answer Posted / ramesh kotha

exex dbms_stats.gather_table_statistics
('<schema>','<tablename>');

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to Declare Fixed Length String Value In PL SQL

1205


Why is sql*loader direct path so fast?

1141


Explain about various levels of constraint.

996


how to calculate the difference between two dates? : Sql dba

1112


What are pl/sql cursor exceptions?

1162


Which are the different case manipulation functions in sql?

1075


what are the authentication modes in sql server? : Sql dba

1116


What is oracle sql developer?

1118


What is difference between cursor and trigger?

1129


what is “go” in t-sql? : Transact sql

1154


What is the need of merge statement?

1092


What sql does db2 use?

1028


what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1113


What is a delimiter in sas?

1124


how to select unique records from a table? : Sql dba

1172