Hello Gerd, First thing to consider: Have you run UPDATE STATISTICS on both systems before doing your tests?
In my experience... if MaxDB has out of date statistics, it will sometimes think the table is small and a table scan will seem easier :) Stephen Gutknecht On Tue, 6 Apr 2004 17:39 , Gerd K�nig <[EMAIL PROTECTED]> sent: >Hi, > >we're wondering about the heavy load our maxdb produces. >After some time of investigation we found out that the database produces >a lot of table scans. >Why we are wondering is, that our currently running 7.3.0.46 doesn't produce >table scans, furthermore this version uses the created indices (and MaxDB >doesn't...). > >An "explain" of a test statement shows us a completely different behaviour of >statement execution. The costvalue from MaxDB is 10-times the value from >the 7.3.0.46 :-(( > [sniip] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
