SQL performantie vraag : Join <> where?

Article View: be.comp.programming

Article #5844

Back to be.comp.programming Previous Next

#5844

From: Rookie
Date: Thu, 06 Feb 2003 09:17

20 lines
1439 bytes

Hey all,

Wat ik me afvraag:

Is
"select * from tabel1 inner join tabel2 on tabel1.ID = tabel2.IDtabel1"
performanter dan
"select * from tabel1,tabel2
where
tabel1.ID = tabel2.IDtabel1" ??

Maw is een join (in de from clause) performanter dan een join in de where
clause ?

Iemand die daar ergens info van vindt op het net? Waarom het juist zo is en
wat het interne verschil is?

Thx in advance

Rookie

Technical Details

Message-ID: <jKp0a.4111$pQ1.400245985@hebe.telenet-ops.be>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-06!sn-xit-09!supernews.com!iad-peer.news.verio.net!news.verio.net!skynet.be!skynet.be!ossa.telenet-ops.be!hebe.telenet-ops.be.POSTED!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: DUTCH,ASCII-7-bit
X-Google-Thread: fcea4,ff28fd67f0304562,start
X-Google-Attributes: gidfcea4,public
X-Google-ArrivalTime: 2003-02-06 01:17:18 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-06!sn-xit-09!supernews.com!iad-peer.news.verio.net!news.verio.net!skynet.be!skynet.be!ossa.telenet-ops.be!hebe.telenet-ops.be.POSTED!not-for-mail
From: "Rookie" <Chiwakee@hotmail.com>
Newsgroups: be.comp.programming
Subject: SQL performantie vraag : Join <> where?
Lines: 22
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <jKp0a.4111$pQ1.400245985@hebe.telenet-ops.be>
Date: Thu, 06 Feb 2003 09:17:03 GMT
NNTP-Posting-Host: 213.118.115.19
X-Complaints-To: abuse@telenet.be
X-Trace: hebe.telenet-ops.be 1044523023 213.118.115.19 (Thu, 06 Feb 2003 10:17:03 CET)
NNTP-Posting-Date: Thu, 06 Feb 2003 10:17:03 CET
Organization: Telenet Internet