Is there any better SQL Statement than this ? Help !!

Is there better SQL Statement than this with this SQL statements ?

It takes long so a time to execute the following SQL statement.

Three select SQL And Two intersect SQL.

Two tables has 350,000 records respectively.

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'



===================================================

Many Thanks !! Received on Mon Jan 27 2003 - 10:48:22 CST