Re: 7.3TC7 Optimizer foibles

Jay Walters wrote: > > That's what I wound up doing, but it costs me an extra step in my process, and an > extra temp table with potentially lots of rows during a transaction which needs to > have a fast response time. > > How safe is a view of a union? That might get me out of some of my temp table > hell. Safe enough. But you need 7.30+, which you have, to create a view containing a UNION for those observing who may want to try this at home on 7.2x and then flame me. Art S. Kagel