Noise words with multiple column likep search

[dave.zahn]

Greetings!

We have the following inverted metamorph index created on a table:

<apicp keepnoise 1>
<SQL "CREATE METAMORPH INVERTED INDEX meta_cmgContent on Content_Table(heading\sub_heading\abstract\body)"></SQL>

When we try to run the following query with any noise words included, it fails to return data:

select page_id, sub_heading from Content_Table where heading\sub_heading\abstract\body likep 'this is';

If we remove any one of the columns from the "to be searched" list, it works fine.

Does anyone have any thoughts on why this would occur? I ran a drop/recreate on the Metamorph index with the new noise setting - do these results indicate that I didn't do that correctly?

Thanks for any assistance.

[mark]

Did you also set keepnoise when doing the search? You need to if you don't want the noise stripped from the query.

Removing a column from the search makes it go linear and not use the index.

View the source of the results page to see what errors/warnings you're getting. They will be in html comments.

[dave.zahn]

Thanks for the information. It turns out that there was an error in the drop/create process for the metamorph index. Once the index was correctly recreated, the problem was resolved.

Thanks again for you time.