Interested to Buy Any Domain ? << Click Here >> for more details...
How can analyze query after generating explain plan ?
- 2 Answers
- 8044 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
Where is pl sql used?
What is multiple partition?
What is the trigger in sql?
What are the different parts of a package?
what happens if you no create privilege in a database? : Sql dba
What is partition by in sql?
What will you get by the cursor attribute sql%rowcount?
What are keys in sql?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
What is cost in sql execution plan?
Which type of cursor is used to execute the dml statement?
What are the types of dbms?
What is forward declaration in pl sql?
What are the different schemas objects that can be created using pl/sql?
Why use truncate instead of delete?
