performance question

From: Uwe Hoell <hoell_at_nospamaeb.de>
Date: Wed, 19 Sep 2001 17:38:23 +0200
Message-ID: <3ba8bbf1$0$232$4d4ebb8e@businessnews.de.uu.net>

Is there a difference in performance for:

select * tableA where exists (select * from tableB where tableA.fk = tableB.pk)

select * tableA where exists (select null dummy from tableB where tableA.fk = tableB.pk)

tia Received on Wed Sep 19 2001 - 10:38:23 CDT

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

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