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

Home -> Community -> Usenet -> comp.databases.theory -> Performance question

Performance question

From: idiot <ivg_at_beer.com>
Date: 2000/01/06
Message-ID: <3874a09e@athene.hdm-stuttgart.de>#1/1

I'm confused of using two methods of corellating the subquery, i. e.
" ... x in (select y ...) ... " and
" ... exists (select * .... where y = x) ... "

is that a fact that one of them always works faster than other or there are nuances?

thanx Received on Thu Jan 06 2000 - 00:00:00 CST

Original text of this message

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