example explain analyze select br_loc,count(insp

How can analyze query after generating explain plan ?

Question Posted / azuan

2 Answers
8032 Views
Thermotech, I also Faced
E-Mail Answers

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

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1179

What is online transaction processing (oltp)?

1015

what is 'mysqld'? : Sql dba

963

What is view? Can we update view

1424

What is the use of sql trace?

946

How do I run pl sql in sql developer?

1107

Where is all the data on the internet stored?

1004

How to read/write files from pl/sql?

1031

What is AUTH_ID and AUTH_USER in pl/sql ?

2180

what is user defined functions? : Sql dba

1022

How does pl sql work?

955

What steps server process has to take to execute an update statement?

973

What are the qualities of 2nf?

1033

what is column? : Sql dba

999

What is consistency?

1113