optimizing where clause?
From: Sinisa <popsin_at_eunet.yu>
Date: Tue, 16 Jan 2001 06:43:14 +0100
Message-ID: <940mvf$dp7$1_at_SOLAIR2.EUnet.yu>
Date: Tue, 16 Jan 2001 06:43:14 +0100
Message-ID: <940mvf$dp7$1_at_SOLAIR2.EUnet.yu>
Hi,
[Quoted] I have one question:
if I have many filters in where clause joined with AND operator:
SELECT * FROM bla, bla
WHERE something = a
AND something = b
AND something = c
which one will be executed first: the first one or the last one. I want to optimize this query but I don't know which one to put first. I [Quoted] [Quoted] know that the most restrictive filter should be executed first, but I don't [Quoted] know in which order will Oracle execute them.
Sinisa Received on Tue Jan 16 2001 - 06:43:14 CET