7.1 optimizer
From: Greg Gehrich - Medimpact <med_at_crash.cts.com>
Date: Thu, 22 Sep 1994 16:50:56 GMT
Message-ID: <CwJIsw.IMH_at_crash.cts.com>
Date: Thu, 22 Sep 1994 16:50:56 GMT
Message-ID: <CwJIsw.IMH_at_crash.cts.com>
Is the cost-based query optimizer as brain dead as it seems? I
analyzed all the tables and indexes and it doesn't pick the most
selective indexes. Performance is down and we have to start the
db up as rule based default. I've heard there were problems
with 7.0 and it was supposed to be fixed in 7.1.
Any help would be appreciated.
Greg Gehrich
MedImpact