How can analyze query after generating explain plan ?
Answer Posted / 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 |
Post New Answer View All Answers
How do you write an index?
Are left and right joins the same?
What are the three forms of normalization?
Is sql harder than python?
How to execute a stored procedure?
What is dynamic query?
how to show all tables with 'mysql'? : Sql dba
What is Materialized View? In What Scenario we Use Materialized View?
differentiate between float and double. : Sql dba
what is the difference between char and varchar data types? : Sql dba
What do you mean by “trigger” in sql?
where are cookies actually stored on the hard disk? : Sql dba
what is the difference between a having clause and a where clause? : Sql dba
What are the advantages of indexing?
Name the operator which is used in the query for pattern matching?