Skip to Content
0
Oct 02, 2009 at 08:27 AM

MaxDB 7.7 bad join performance

51 Views

Hello,

after upgrading from MaxDB 7.6 to MaxDB 7.7 we got performance problems executing a sql query. It is a join over 3 tables, nothing special, 7.6 ran the query in less a second, 7.7 needs about 1 minute 50 sec. to comlpete. Running explain against both versions gives the same strategy, I also did a statistics update after the db upgrade. Are there new parameters in 7.7 relating to joins?

Thanks an best regards

Tiberius