How can analyze query after generating explain plan ?
Answers were Sorted based on User's Feedback
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 |
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 |
What is a sql statement?
Why do we create views in sql?
how would concatenate strings in mysql? : Sql dba
Give the structure of the function ?
What is the best free sql database?
Is sql open source?
Can we use pl sql in mysql?
What is the limitation on the block size of pl/sql?
What are the packages in pl sql?
What is program debugging?
What is a loop in sql?
Where is sql database stored?