Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Is there better SQL statement than this ?

Is there better SQL statement than this ?

From: Park Yeon Jo <kudos12_at_netian.com>
Date: 27 Jan 2003 04:42:22 -0800
Message-ID: <d7fe264d.0301270442.7e9fa9bd@posting.google.com>


It takes too long time to execute the following SQL statement ?

Is there better SQL statement than this ?

I didn't make any Indexes on two tables yet.

Please give me the hints.         


        select pmc.oid from productModelParam pmp, productModelCategory pmc
	where pmc.oid = pmp.oid
	and pmc.categoryValue = '3E965F2E-F64E-9ECE-1B3872409AC42428'
	and pmp.paramValue = 'TH'
	
	intersect 
	
	select pmc.oid from productModelParam pmp, productModelCategory pmc
	where pmc.oid = pmp.oid
	and pmc.categoryValue = '3E965F2E-F64E-9ECE-1B3872409AC42428'
	and pmp.paramValue = '50Vdc'
	  
	intersect 
	
	select pmc.oid from productModelParam pmp, productModelCategory pmc
	where pmc.oid = pmp.oid
	and pmc.categoryValue = '3E965F2E-F64E-9ECE-1B3872409AC42428'
	and pmp.paramValue = '0603'
Received on Mon Jan 27 2003 - 06:42:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US