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
Yes subquery flattening IS in 7.30. I seem to be suffering from versionitis. Too many features in too many releases and I've finally lost track. Art S. Kagel Octav Chiriac wrote: > > 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