How can analyze query after generating explain plan ?
- 2 Answers
- 7322 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
Explain exception handling in pl/sql?
Is sqlite good enough for production?
How does sql store data?
Can we insert data into materialized view?
How to load data with sql*loader?
Is ms sql traffic encrypted?
what are the type of locks ? : Sql dba
What is triggering circuit?
What are the differences between in and exists clause?
what is data control language? : Sql dba
What is nosql db?
what is the difference between clustered and non clustered index in sql? : Sql dba
What is constant in pl sql?
define sql update statement ? : Sql dba
What are sql data types?
