hello all,
I have the following question (MaxDB 7.5), with the following statement:
select * from bsis where mandt=? and bukrs=? and
(hkont in (?,?,?,?) or hkont in (?,?,?) or hkont in (?,?,?));
The table has a PK on mandt, bukrs, hkont, ...
When I do not use parameters maxdb uses 'DIFFERENT STRATEGIES FOR
OR-TERMS'
and uses hkont in the PK index.
When I use parameters, hkont is not used as a 'RANGE CONDITION'. I guess
this is
because without knowing values the different sets may overlap. Without
using hkont
as index condition, the statement is very inefficient because mandt and
bukrs
is not selective.
But, could MaxDB not automatically simplify above query to "hkont in
(?,?,?,?,?,?,?,?,?,?)",
(especially if it is written as stupid and simple as above :-) ?
I am going to adapt the query, but still wanted to ask.
greetings
Andreas
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
