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 happens if you no create privilege in a database? : Sql dba
what is acid property in database? : Sql dba
How is use pl and sql?
What are different categories of sql commands?
What do you understand by pl/sql cursors?
How many columns should be in an index?
Does sql full backup truncate logs?
Does truncate free space?
How do I turn a list into a table?
Can sql function call stored procedure?
what are the properties and different types of sub-queries? : Sql dba
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
How many subqueries can be nested in a statement?
what are the advantages of using stored procedures? : Sql dba
How delete a row in sql?
