Interested to Buy Any Domain ? << Click Here >> for more details...
How can analyze query after generating explain plan ?
- 2 Answers
- 8050 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
What is sql query optimization?
What is difference between function and trigger?
What is difference between joins and union?
Explain the uses of control file.
What is the difference between view and stored procedure?
how many sql ddl commands are supported by 'mysql'? : Sql dba
How to order siblings in oracle hierarchy queries?
What does sql stand for?
Is coalesce faster than isnull?
What is bulk compiling in pl/sql.?
How do you know if a relationship is 2nf?
Is null operator in sql?
What does select * from mean in sql?
what is an extent ? : Sql dba
Is foreign key mandatory?
