HI,

Thanks for your response.

I'll explain in more detail. We are trying to provide custom rank to a search.

Table2 and table3 are temp tables and we are using FTS functions to...

HI,

Thanks for your response.

I'll explain in more detail. We are trying to provide custom rank to a search.

Table2 and table3 are temp tables and we are using FTS functions to...

Hi,

I have already tried creating primary and secondary(value) xml indexes on the table1.column but have no impact.

Hi,

I'm using sys.dm_fts_parser to get values to table3.column. User provides the text to search and parser finds diffrnet combination of words.

XML datatype is used in charindex comparision from table1 and...