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