I think they are all indexed, yes.
I have an index on :
bb.ver_id
b.batch_bestel_id
k.klant_id (k1 is the same)
b.batch_lever_id
l.ver_lev_id
Tnx in advance
I am new to this mailinglist thing, so i don't know how to reply :-$
Sorry...
- Original Message -
From: Dobromir Velev
To: Koe
- Original Message -
From: Dobromir Velev
To: Koen Van Mulders ; [EMAIL PROTECTED]
Sent: Thursday, December 18, 2003 3:14 PM
Subject: Re: Problem with EQ_REF and ALL
Hi,
Have you indexed the fields you're using in the JOIN clauses?
Dobromir Velev
[EMAIL PROTECTED]
- Original M
