Re: index not being pick up

[Raf Mahn]

Thanks for the tip. I tried adding the variables to a table and joining, see below, no luck :( .

If I remove the or condition "or flag.`override_enabled` = true" it will work, but I need the or condition.

create or replace algorithm=merge view `vw_property`
as select property.*
FROM `property` join flag on (`property`.`scope_id` = flag.`scope_id` or flag.`override_enabled` = true)
with check option;

id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE flag ALL override_enabled_idx,scope_id_idx NULL NULL NULL 1 NULL
1 SIMPLE property ALL uq_reference_idx NULL NULL NULL 15 Using where; Using join buffer (Block Nested Loop)

create or replace algorithm=merge view `vw_property`
as select property.*
FROM `property` join flag where (`property`.`scope_id` = flag.`scope_id` or flag.`override_enabled` = true)
with check option;

id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE flag ALL override_enabled_idx,scope_id_idx NULL NULL NULL 1 NULL
1 SIMPLE property ALL uq_reference_idx NULL NULL NULL 15 Using where; Using join buffer (Block Nested Loop)