This is a 3-table view. DALY_PROC_LBS has about 75,000 records, CNTRMAST has about 350 and LKUPGRAD has about 100. I link from DALY_PROC_LBS to CNTRMAST on CUR_CC and from DALY_PROC_LBS to LKUPGRAD on GRADE. I did try making a compound index on PRODDATE and CUR_CC but that didn't do any good. The linking columns are each indexed on the supporting/lookup tables but are not indexed in DALY_PROC_LBS.
Ben's suggestion of setting MANOPT ON worked very well. After doing this I got very similar results to the other variations by stating AND SMRYFLAG = 'M'. Thanks for the suggestions. Mike -----Original Message----- From: [EMAIL PROTECTED] [mailto:alb7007@;netscape.net] Sent: Friday, October 11, 2002 6:03 PM To: [EMAIL PROTECTED] Subject: Re: SELECT clause performance variations Have you tried a compound index, assuming Daly_proc_view is a table? CREATE INDEX SearchDalyProcView ON DALY_PROC_VIEW (PRODDATE,GRADE,SMRYFLAG) If Daly_proc_view is a view, restructuring the view syntax can work wonders at times. "Ben Petersen" <[EMAIL PROTECTED]> wrote: >Mike, > >These variations > >> This works well: ================================================ 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/
