Re: 7.1 optimizer

In article <CwJIsw.IMH_at_crash.cts.com>, med_at_crash.cts.com (Greg Gehrich - Medimpact) writes:
|>
|> 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
|> greg_at_medimpact.com
|>

The word I've been hearing is don't use it; it doesn't work. And I've seen such messages posted many times. I hadn't heard that it would be fixed in 7.1. Thanks for the info.

                                Teresa Larson

+~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~+
| Teresa A. Larson - Hughes STX Corporation                            |
| NASA/GSFC Code 933.0                        voice:  (301) 286-7867   |
| Greenbelt, Maryland  20771                  fax:    (301) 286-1777   |
| Teresa.Larson_at_gsfc.nasa.gov                                          |
+~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~+
			Standard disclaimer ...