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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between ms sql and mysql?

921


How do I view tables in sql developer?

891


Is sql harder than python?

1046


Can we use distinct and group by together?

1003


How do I create an index in word?

972


Explain the working of primary key?

1046


what is a trigger? : Sql dba

984


What are all different types of collation sensitivity?

982


What is data manipulation language?

1143


What is difference between table and view?

992


What are user defined functions?

954


Show the two pl/sql cursor exceptions.

1121


how to drop an existing view in mysql? : Sql dba

1006


What is view explain with example?

891


Which is better join or inner query?

970