I managed to define my 1st full text search index in my db. My problem is noise words. According to the BOL they are used when defining the index. Fine. I defined my index using the language spanish in my columns. My problem is now when running a query containing a so called Noise word. This query returns 47 rowsSELECT * FROM vwSitiosSchema2009 WHERE CONTAINS(Sd_Desc, '"diseño*" AND "web*" ', LANGUAGE 3082);
This query returns 0 rowSELECT * FROM vwSitiosSchema2009 WHERE CONTAINS(Sd_Desc, '"diseño*" AND "web*" AND "dos"', LANGUAGE 3082);
This last query contains a Noise word, dos, as define in noiseESN.txt. From what I read the search should ignore it and retrieve the same number of rows as the 1st query. What could I be doing wrong ?jean-lucwww.corobori.com
Should I strip noise words ?
Posted - 2009-03-11 : 21:28:37
