[Maria-discuss] problem with optimizer

21 Aug 2015

      Hi guys
I'm running two queries:

first:

explain
SELECT lote_spa,mov_id
FROM est_mov
WHERE
unidade_id=1001 AND lote_tipo='v' AND
lote_spa IN
(1150150.0,1150532.0,1152187.0,1152361.0,1155813.0,1156244.0,1156654.0)
AND item_id=67 AND item_id_red=1423

it use primary key and key_len =16

but including a new = element [AND oe_tipo='oe' ]:

explain
SELECT lote_spa,mov_id
FROM est_mov
WHERE
unidade_id=1001 AND lote_tipo='v' AND
lote_spa IN
(1150150.0,1150532.0,1152187.0,1152361.0,1155813.0,1156244.0,1156654.0)
AND item_id=67 AND item_id_red=1423 AND oe_tipo='oe'

it use primary key but key_len=4 (near to a full table scan)

what's wrong?

-- 
Roberto Spadim