Thunderstone Support Forums

I have a table similar to the html table from the dowalk_beta script. Here's the definition of the metamorph index:
create metamorph inverted index xhtmlbod on html(Title\Description\Keywords\Body)

I want to perform a keyword search that only search the keyword field of a record along with a full text search that searches only the Title and Body fields. When I try the following query,

<sql "select 'http://'+Url Url, Title, $$rank Rank from html where Title\Body\Metadata likep $defaultquery and Keywords like $keywordquery"></sql>

I get the following error:
<!-- 115 /vortex/search:725: Query would require linear search -->

How would I propery construct the query to do what I need?

You need to create separate indices on the fields the way you want to search them. One on Title\Body\Metadata and one on Keywords.

Would I keep the index on Title\Body\Metadata as a metamorph index? What type of index would I use on the field Keywords?

like and likep both use metamorph [inverted] indices.

I thought that I read somewhere that you should only have 1 metamorph index on a table. Are you saying that I need to create a metamorph index for Title\Body\Metadata and a separate one for Keywords?

I'm not sure where you got that. If you find it again let me know where.
You may have as many indices of any type as are needed.