Interested to Buy Any Domain ? << Click Here >> for more details...
How can analyze query after generating explain plan ?
- 2 Answers
- 7939 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 difference between rank () row_number () and dense_rank () in sql?
How can you select unique records from a table?
what is meant by nl2br()? : Sql dba
What is rownum and rowid?
what is oracle database ? : Sql dba
What is your daily office routine?
What is the difference between cross join and natural join?
How do I turn a list into a table?
Can a select statement fire a trigger?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
What is the sql query to display the current date?
What are the string functions in sql?
Does sql support programming?
what is a table in a database ? : Sql dba
What does dml mean?
