>> I have an index set up which is "ttk_keyword+ttk_type".

Paul,

There's your problem. To get optimization you need an index on ttk_keyword and another index on ttk_type.