How can analyze query after generating explain plan ?
- 2 Answers
- 7482 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
How does a covering index work?
What found sql?
When are we going to use truncate and delete?
Explain the difference between sql and mysql.
Is progress software supports to ( pl/sql )?
What is set serveroutput on in pl sql?
Why stored procedures are faster than query?
What is difference between joins and union?
What is orm in sql?
Can a composite key be null?
what are the properties and different types of sub-queries? : Sql dba
What is the difference between row level and statement level trigger?
what is the syntax for using sql_variant_property? : Transact sql
Why do we need unique key in a table?
What is the difference between the sql*loader and import utilities? : aql loader
