How can analyze query after generating explain plan ?
- 2 Answers
- 7132 Views
- Thermotech, I also Faced
- E-Mail Answers
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
Why do we use procedures?
What is join view in sql?
How do you remove duplicate records from a table?
What is sql and also describe types of sql statements?
how many columns can be used for creating index? : Sql dba
Why do we use joins?
Which join is like inner join?
what does the t-sql command ident_incr does? : Transact sql
What is sqlite format?
How do you truncate?
Name the operator which is used in the query for pattern matching?
Why do we use %rowtype & %type in plsql?
What are the subsets of sql?
Why do we create views in sql?
What is minus?
