Andreas,
-----Original Message-----
>select * from bsis where mandt=? and bukrs=? and
> (hkont in (?,?,?,?) or hkont in (?,?,?) or hkont in (?,?,?));
>But, could MaxDB not automatically simplify above query to "hkont in
>(?,?,?,?,?,?,?,?,?,?)",
>(especially if it is written as stupid and simple as above :-) ?
avoid stupid statements that's probably the best way! But in earnest,
we working on an advanced query optimization comming with MaxDB 7.6 that
will eliminate such things as unnecessary from-selects ("select * from
(select * from tab)") and other in order to speed up execution. I put
your issue on the todo-list - but it won't come with 7.5.
Regards, Dirk
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
