Answer Posted / ashok
Explain plan shows the details of the joins cordinality and
time taken.we can easily find the what join is taking much
time in a SQL query. by clicking F5 you can see the explin
plan in PL/SQL developer.
Is This Answer Correct ? | 11 Yes | 7 No |
Post New Answer View All Answers
What is informix sql?
What are different types of keys?
How you improve the performance of sql*loader? : aql loader
How do I save a sql query?
What is sqlcommand?
Why are indexes and views important to an organization?
What is bitemporal narrowing?
What is meant by cursor in sql?
What are aggregate and scalar functions?
what is cursor. write example of it. What are the attributes of cursor.
How do I view a view in sql?
Can we use pl sql in mysql?
How to check if a column is nullable before setting to nullable?
What are the different schemas objects that can be created using pl/sql?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?