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 can analyze query after generating explain plan ?

Question Posted / akshay

Answers were Sorted based on User's Feedback



How can analyze query after generating explain plan ?..

Answer / chiranjeevi

After generating explan plan the out put of the query
stored in plan_table.from this table if you finding any
table access (full) in output,the query having perfomence
problem.

according you can create the index or primary key or unique
in proper table.

Is This Answer Correct ?    3 Yes 0 No

How can analyze query after generating explain plan ?..

Answer / azuan

example

explain analyze select br_loc,count(insp_id) from insp where
date_create between '2010-07-01 00:00:00' and '2010-07-31
23:59:59' group by br_loc

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

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

0 Answers  

Explain character-manipulation functions?

0 Answers  

ex: take one schema in that t1,t2,.....tn tables and you don't no the table name also. write a procedure if enter columns name then display the maching columns .otherwise display the unmatch columns.

1 Answers   Zensar,

what are enums used for in mysql? : Sql dba

0 Answers  

What is a constraint. Types of constraints ?

5 Answers   Accenture, BirlaSoft,

What are wait events. Describe the wait event tables.

1 Answers   CTS,

How to move files from one directory to another in pl sql?

0 Answers  

Does view store data in sql?

0 Answers  

Can we use join in subquery?

0 Answers  

How do you optimize a query?

0 Answers  

How to display the records between two range in Oracle SQL Plus?

0 Answers   MCN Solutions,

Differentiate between sga and pga.

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories