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
What is difference between ms sql and mysql?
How do I view tables in sql developer?
Is sql harder than python?
Can we use distinct and group by together?
How do I create an index in word?
Explain the working of primary key?
what is a trigger? : Sql dba
What are all different types of collation sensitivity?
What is data manipulation language?
What is difference between table and view?
What are user defined functions?
Show the two pl/sql cursor exceptions.
how to drop an existing view in mysql? : Sql dba
What is view explain with example?
Which is better join or inner query?