Re: 9.40 query optimiser problem

Thanks Art, David and Paul - distributions it is! However, it is interesting that the problem goes away if you set: OPT_GOAL -1 # ALL_ROWS Counter-intuitive? -- Regards, Doug Lawry www.douglawry.webhop.org "Doug Lawry" <lawry@nildram.co.uk> wrote: > A client has IDS 9.40.FC1 on HP-UX with: > > OPTCOMPIND 0 # Nested loop joins preferred > OPT_GOAL 0 # FIRST_ROWS> > UPDATE STATISTICS (no distributions) has been run.> > According to "sqexplain.out", queries involving several tables, with a > fixed condition on one table for which an index exists and indexed joins > to the other tables, will not start with the first table without optimizer > directives, whereas this was fine in 9.30! Any ideas? I consider that this > would be a bug in 9.40 if it cannot be made to work correctly without > distributions. > > -- > Regards, > Doug Lawry > www.douglawry.webhop.org