Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between the query and corelated
query
- 8 Answers
- 20963 Views
- HSBC, IBM, TCS, Xenosoft, I also Faced
- E-Mail Answers
Answer Posted / lova raju allumalla
when performing joins on two or more tables, we normally
write a query making use relational operators such as =
etc. which means each and every row of every table is
compared with each other,which is a unwanted situation when
looked in the perspective performance issue. where as
making use of corelated query one can minimise the tedoius
checks as described above. consider the example below with
a normal join
select * from emp e,dept d where e.deptno=d.deptno;
now the above same can be performed by using the co related
query
select * from emp where deptno in (select deptno from dept);
u can now make up the difference, in the first approach in
emp table, each row deptno value compared for each row
deptno value of dept table.where as in second approach the
(select deptno from dept) is executed only once for all
checks of the outer query select * from emp where deptno
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is pl/sql table? Why is it used?
What is the purpose of design view?
what are the different tables present in mysql? : Sql dba
What is anonymous block in sql?
How show all rows in sql?
What does sql stand for?
How do I run a sql query?
What is scope and visibility in PL/SQL?
What programs use sql?
How do I count records in sql?
What is cursor status?
Why is sharding used?
What is delimiter in pl sql?
what is unique key constraint? : Sql dba
What are inbuilt functions in sql?
