Larry - Here's a long shot. What if you remove the index from the dept field in the database, then add it back? Maybe there's a priority order set in the order they are stored in the structure file.
Sami ------------------------------------------ Sami Aaron Software Management Specialists 19312 W 63rd Terr Shawnee KS 66218 913-915-1971 mailto:[EMAIL PROTECTED] www.softwaremgmt.com > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Lawrence > Lustig > Sent: Wednesday, September 15, 2004 10:05 AM > To: RBG7-L Mailing List > Subject: [RBG7-L] - RE: Help me de-optimize this query (calling Bill > Downall!) > > > > Did you try SET MANOPT ON and THEN switching the WHERE clauses? > > I did, without effect. When I looked in the Docs, I saw that MANOPT only > affects multiple table joins. > > > Did you try > > putting the where clause you want processed first in PARENS? > > I tried putting parens around various parts of the WHERE clause, without > effect. > -- > Larry > > > >
