| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Is there better SQL statement than this ?
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
![]() |
![]() |