Interested to Buy Any Domain ? << Click Here >> for more details...
How can analyze query after generating explain plan ?
- 2 Answers
- 8161 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 to read/write files from pl/sql?
Can we use update in sql function?
how to analyze tables with 'mysqlcheck'? : Sql dba
explain the delete statements in sql
How do I install sql?
Which normal form is best?
What is a primary key sql?
How do I find duplicates in a single column in sql?
How can I speed up sql query?
what is the difference between where clause and having clause? : Sql dba
Why function is used in sql?
What does trigger mean in psychology?
What is left join in sql?
Explain the components of sql?
Is it possible to create the following trigger: before or after update trigger for each row?
