How can analyze query after generating explain plan ?

Question Posted / akshay

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

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