Interested to Buy Any Domain ? << Click Here >> for more details...
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 join an inner join?
Does normalization improve performance?
Can we write ddl statements in functions?
Explain clause in sql?
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
What is the difference between nested table and varray?
Can we create view in stored procedure?
What is a system versioned table?
Why do we need pl sql?
What is %type in sql?
how to include numeric values in sql statements? : Sql dba
Why use subqueries instead of joins?
what is datawarehouse? : Sql dba
What are triggers in sql?
