Interested to Buy Any Domain ? << Click Here >> for more details...
How can analyze query after generating explain plan ?
- 2 Answers
- 8149 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
When are we going to use truncate and delete?
How do I install sql?
Can we write ddl statements in functions?
explain the options of myisamchk to improve the performance of a table. : Sql dba
what is transaction? : Sql dba
What is trigger in sql? Explain
What are the advantages of normalization?
What is procedure and function in sql?
How is data stored in sql?
What is forward declaration in pl sql?
Is clustered index a primary key?
What are the operators used in select statements?
What does desc stand for?
Explain dml and ddl?
How sql query is executed?
