Limit of AND, OR in where clause ???
Date: 26 Aug 2002 02:23:10 -0700
Message-ID: <6c353a07.0208260123.56bc57ed_at_posting.google.com>
When I start this SELECT, ORACLE 8.1.6 doesn´t respond;
when I minimize the AND/OR Section in the WHERE clausel
oracle responses correctely.
SELECT DISTINCT
What´s the Problem ?
Gert
B.CHR_TABLE_NAME, B.BLN_ROOT_TABLE FROM TL_ATTR_CLASS_DTABLE_005
A, TM_DATA_TABLE_005 B
WHERE
(((A.FIELD1 = 3) AND (A.FIELD2 = 1)) OR
((A.FIELD1 = 12) AND (A.FIELD2 = 1)) OR
((A.FIELD1 = 100005) AND (A.FIELD2 = 5)) OR
((A.FIELD1 = 100006) AND (A.FIELD2 = 5)) OR
((A.FIELD1 = 100007) AND (A.FIELD2 = 5)) OR
((A.FIELD1 = 100011) AND (A.FIELD2 = 5)) OR
((A.FIELD1 = 100013) AND (A.FIELD2 = 5)) OR
((A.FIELD1 = 100014) AND (A.FIELD2 = 5)) OR
((A.FIELD1 = 100017) AND (A.FIELD2 = 5)) OR
((A.FIELD1 = 100027) AND (A.FIELD2 = 5)) OR
((A.FIELD1 = 100028) AND (A.FIELD2 = 5)) OR
((A.FIELD1 = 100058) AND (A.FIELD2 = 5)) OR
((A.FIELD1 = 100060) AND (A.FIELD2 = 5)) OR
((A.FIELD1 = 100066) AND (A.FIELD2 = 5)) OR
((A.FIELD1 = 100021) AND (A.FIELD2 = 5)) OR
((A.FIELD1 = 100061) AND (A.FIELD2 = 5)) OR
((A.FIELD1 = 100067) AND (A.FIELD2 = 5)) OR
((A.FIELD1 = 100074) AND (A.FIELD2 = 5)) OR
((A.FIELD1 = 100077) AND (A.FIELD2 = 5)) OR
((A.FIELD1 = 100079) AND (A.FIELD2 = 5)) OR
((A.FIELD1 = 100090) AND (A.FIELD2 = 5)) OR
((A.FIELD1 = 100092) AND (A.FIELD2 = 5)) OR
((A.FIELD1 = 100093) AND (A.FIELD2 = 5)) OR
((A.FIELD1 = 100094) AND (A.FIELD2 = 5)) OR
((A.FIELD1 = 100095) AND (A.FIELD2 = 5)) OR
((A.FIELD1 = 100096) AND (A.FIELD2 = 5)) OR
((A.FIELD1 = 100097) AND (A.FIELD2 = 5)) OR
((A.FIELD1 = 100129) AND (A.FIELD2 = 5)) OR
((A.FIELD1 = 100176) AND (A.FIELD2 = 5)) OR
((A.FIELD1 = 100178) AND (A.FIELD2 = 5)) OR
((A.FIELD1 = 100179) AND (A.FIELD2 = 5)) OR
((A.FIELD1 = 100180) AND (A.FIELD2 = 5)) OR
((A.FIELD1 = 100181) AND (A.FIELD2 = 5)) OR
((A.FIELD1 = 100182) AND (A.FIELD2 = 5)) OR
((A.FIELD1 = 100183) AND (A.FIELD2 = 5)) OR
((A.FIELD1 = 100184) AND (A.FIELD2 = 5)) OR
((A.FIELD1 = 100185) AND (A.FIELD2 = 5))) AND
A.ID_MDA_TABLE = B.ID AND A.ID_CRT_MDA_TABLE = B.ID_CRT
ORDER BY
B.BLN_ROOT_TABLE DESC
Received on Mon Aug 26 2002 - 11:23:10 CEST