1900 10:21:13 -0000
To: "LazyDBA Discussion" <[Email Address Removed] "ritu" <oracledba-ezmlmshield-x28333651.[Email Address Removed] Thu, 17 Jun 2004 15:15:13 +0530
Subject: Optimize SQL Query with IN

Hi all,



I am having performance problem with one query written like this.



Select A, B from Emp where emp_no in (select distinct emp_no from
Inventory where pkey in (select pkey from view_Dept where Dept ='ABC))



All the two tables and one view is required to be used.The problem is I
am creating a cursor for this and after that printing the values one by
one.



Query is running finr but it is very slow.



For all inputs ..



Thanks in advance.



-Ritu


Oracle LazyDBA home page