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

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

how will u find statistics of a database objects?

Question Posted / pgnath

Answers were Sorted based on User's Feedback



how will u find statistics of a database objects? ..

Answer / ramesh kotha

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

Is This Answer Correct ?    1 Yes 0 No

how will u find statistics of a database objects? ..

Answer / senthil vinayagam

Using analyze command

Is This Answer Correct ?    2 Yes 2 No

Post New Answer

More SQL PLSQL Interview Questions

What is referential integrity ?

3 Answers   BirlaSoft,

How do you use join?

0 Answers  

What is the reports view in oracle sql developer?

0 Answers  

How to get help at the sql prompt?

0 Answers  

Can you selectively load only those records that you need? : aql loader

0 Answers  

Can you sum a count in sql?

0 Answers  

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

0 Answers  

What is string join?

0 Answers  

What is optimistic concurrency control? : Transact sql

0 Answers  

What is vector point function?

0 Answers  

need to split a string into separate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

2 Answers  

difference between anonymous blocks and sub-programs.

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories