Hi Christian,
Thanks for response. I'v found it.. right... when starts with "%" its can't be optimized.. I remove lead "%" for test.. SYS(3054) returns again "partial optimized" - but all indexex now using for rushmore optimization.. and I exactly check index expression for each operand. why partial again... ?!
Is there way to write optimized query wich will return same result.. but without using LIKE % ?

Thanks
Denis.


>Hello,
>
>a LIKE condition which starts with % cannot be optimized.
>
>Regards
>Christian