Larry Did you try SET MANOPT ON and THEN switching the WHERE clauses? Did you try putting the where clause you want processed first in PARENS?
David David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "Lawrence Lustig" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, September 15, 2004 9:41 AM Subject: [RBG7-L] - RE: Help me de-optimize this query (calling Bill Downall!) > > Could it be a good idea to swap the 2 clauses of AND? > > R:Base makes the decision of which index to use based on it's internal analysis > of the "quality" of the index, without looking at placement in the R: prompt. > I did try moving the clauses around, with no effect. > -- > Larry > >
