RE: Temp dbspace problem

Subquery flattening DOES exist in 7.3x...I had never seen it freak out so badly before in my 7.3UC5 instance, but that was most likely because my indexes were pretty screwed up in my 7.31UC2 instance (creation script was not what it should have been, to make a long story short). We have been doing very *VERY* well in our 7.3UC5 instance for just under a year or so. So...word to the wise (or, wiser than me)...it might not be a bug...run a dbschema on the table and make sure your indexes are cool, even if you thought you were sure! Best regards, Ben Guerard -----Original Message----- From: Octav Chiriac [mailto:com@netinfo-moldova.com] Sent: Wednesday, August 25, 1999 10:53 AM To: Art S. Kagel Cc: informix-list@iiug.org Subject: Re: Temp dbspace problem On Wed, Aug 25, 1999 at 01:10:00PM -0400, Art S. Kagel wrote: > drumzspace wrote: > > > > In article <37C2F4C3.BD9361F5@bloomberg.net>, > > kagel@bloomberg.net wrote: > > > It may be sub-query flattening, a new feature of the 7.31 optimizer > > that > > > tries to unwind corellated sub-queries into ordinary joins at runtime > > so > > > that the query can be executed, in theory, more quickly. However, if > > you .. > > > > After I triple checked the sqexplain.out file against the indexes on > > one of the tables I found that the whole set of indexes was bad. One > > of those so-close-you-don't-even-see-it things. Since I had never seen > > this extreme behavior with 7.3UC5's subquery flattening before I hadn't > > That's because 7.30 did not do sub-query flattening it is a 7.31 feature. > > Art S. Kagel > It's interesting. I thought subquery flattening did apeare in 7.30. At least in my release 7.30UC2 in UW7 the NOSUBQF env variable really works. Well, may be I don't understand something. What does NOSUBQF in 7.30 ? Thank You, Octav -- Octav Chiriac Phone: (373) 2 22 99 67 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 22 84 88 Moldova, Republic of mailto:com@netinfo-moldova.com