Thunderstone Support Forums

I created a metamorph inverted index using the following statement:

create metamorph inverted index xtblbod on tbl(title\body\description)

I want to give the user the option to select which fields to search on. So if the user wants to search on the title field only, how would I construct the query? I tried using:

select * from tbl where title like 'search'

but I get the "Query 'school' would require linear search" error which I know is happening because the other parts of the virtual field are not included in the query.

You have to index the same combination of fields you want to search. So you'll also need an index on just "title'.

So I would have to create separate indexes for every possible combination of fields (title\body, title\description, ...)?

Yes.