what is the difference between the query and corelated
query
- 8 Answers
- 21150 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 are all the common sql function? : Sql dba
how to escape special characters in sql statements? : Sql dba
Can delete statement be rollbacked?
how to start mysql server? : Sql dba
what is bcp? When does it used? : Sql dba
Does group by remove duplicates?
What is the current version of postgresql?
Is primary key clustered index?
What is the best sql course?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
What is your daily office routine?
Is primary key always clustered index?
what are the advantages of sql ? : Sql dba
what is dbms? : Sql dba
how many tables will create when we create table, what are they? : Sql dba
