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
Is sql a programming?
What is set serveroutput on in pl sql?
Does group by remove duplicates?
What are primary key and foreign key and how they work?
How to write a query to show the details of a student from students table whose
what is bdb (berkeleydb)? : Sql dba
what are the authentication modes in sql server? : Sql dba
How do I view stored procedures?
What are tables and fields?
What is pl/sql table? Why it is used?
Can sql function call stored procedure?
What is where clause in sql?
What are the commands used in sql?
How do I write a cron which will run a sql query and mail the results to agroup?
Can you select everything, but 1 or 2 fields, without writer's cramp?