Difference between sub query and nested query ?
Answer Posted / roshan
ONE THING I WOULD LIKE TO TELL.. SUBQUERY RUNS MUCH FASTER
THAN CO-RELATED QUERY..
BECAUSE EACH TIME IT HAS TO COMPARE THE OUTER QUERY IS
EVALUATED EACH TIME............
Is This Answer Correct ? | 7 Yes | 4 No |
Post New Answer View All Answers
What is a system tablespace?
What happens if recursive calls get out of control?
How to define a cusotmer as a supplier in ORACLE R12
How to write text literals in oracle?
How to load data through external tables?
master table and child table performances and comparisons in Oracle ?
Compare and contrast between sql and sql server and explain its various functions?
What is SQL Tuning Advisor in Oracle?
How to connect to oracle using service name instead of sid?
How to install oracle odbc drivers?
What is a subquery?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
What are the attributes of the cursor?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
How to use an explicit cursor without open statements?