> The SMRYFLAG column is not indexed whereas PRODDATE is. My 1 gig database > gets reloaded each morning and I usually do an UNLOAD ALL and rebuild the > database at least once a week. I tried Ben Peterson's suggestion about > setting MANOPT ON and that did the trick.
Mike: If you want some more insight into exactly what is going on, look up the notes from Wayne's presentation at April's conference. He showed how to use the EXPLAIN setting to actually see what order things are being evaluated -- a useful tool for this kind of situation where the query optimizer is getting fooled. -- Larry ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
