Stack Overflow
Stack Overflow

Questions tagged [fulltext-index]

123 questions
69
votes
7 answers

How can I know when SQL Full Text Index Population is finished?

We are writing unit tests for our ASP.NET application that run against a test SQL Server database. That is, the ClassInitialize method creates a new database with test data, and the ClassCleanup deletes the database. We do this by running .bat…
GarethOwen
  • 6,075
  • 5
  • 39
  • 56
26
votes
6 answers

Full text search vs LIKE

My question is about using full text search. As I know like queries which begin with % never use index : SELECT * from customer where name like %username% If I use fulltext for this query can I take better performance? Can SQL Server use fulltext…
profvm
  • 261
  • 1
  • 3
  • 3
24
votes
3 answers

How to find Full-text indexing on database in SQL Server 2008?

Hi I am looking for a query that is able to find Full text indexing on all tables and columns within a database using SQL Server 2008. Any information or help that can be provided for this is welcomed
Tweet Head
  • 241
  • 1
  • 2
  • 4
20
votes
3 answers

SQL Server: Normal Index vs. Fulltext Index

what exactly is the difference (and advantages/disadvantages) between a fulltext index and a regular index on a varchar column? When would I use which index? I have a multitude of varchar columns (addresses - city name, street name etc.) which I…
Alex
  • 75,813
  • 86
  • 255
  • 348
15
votes
5 answers

set new value for "ft_min_word_len " FULLTEXT in mysql

I changed to "ft_min_word_len" = 4 by my-innodb-heavy-4G.ini located in my system path "C:\Program Files\MySQL\MySQL Server 5.1" , but when i run SHOW VARIABLES LIKE 'ft_min_word_len' I got still result value= 4. I did not find this variable in…
Rahul Rawat
  • 999
  • 2
  • 17
  • 40
13
votes
3 answers

Creating FullText Index on Docx files in a FileTable

I'm working on a document storage. Therefore I plan to use SqlServer 2012 with file tables. Now after some tests it seems like the SqlServer only indexes doc and not docx files. I also installed the Microsoft Filter Pack 2.0. Does somebody know how…
Boas Enkler
  • 12,264
  • 16
  • 69
  • 143
13
votes
1 answer

Mongo $text query: return docs "starting with" string before others

Let's say I have a mongo collection with a text index on the itemName field with these 3 documents: { _id: ..., itemName: 'Mashed carrots with big carrot pieces', price: 1.29 }, { _id: ..., itemName: 'Carrot juice', price:…
Patrick DaVader
  • 2,133
  • 4
  • 24
  • 35
12
votes
3 answers

Show a tables FULLTEXT indexed columns

I'm looking to run a query that will return a list of columns in a table that are FULLTEXT indexed. The table is in MyISAM format and i'll be using php to construct the query. Ideally i would run the query and it would return the information so i…
th3hamburgler
  • 624
  • 2
  • 8
  • 23
8
votes
2 answers

Can I define which word breakers to use when building a mssql fulltext index?

I have created a fulltext catalog that stores the data from some of the columns in a table, but the contents seem to have been split apart by characters that I don't really want to be considered word delimiters. ("/", "-", "_" etc..) I know that I…
Zaz
  • 3,017
  • 2
  • 21
  • 28
6
votes
1 answer

USE INDEX and MATCH on another FULLTEXT index gives error "Can't find FULLTEXT index matching the column list"

Working now on a vBulletin board, which runs on MySQL 5.6.21 with InnoDB table engine. There is a default query in vBulletin, which uses index hint on one column and the same time uses fulltext index on another two columns. The query looks…
Harutyun Drnoyan
  • 166
  • 8
5
votes
1 answer

When does full text index update in sql server?

I'm using a full-text search in one of my stored procedures. Prior to that (typical example would be several minutes) I'm inserting items into a table that has full-text index and some 3.5 million rows in the table. The thing is that the item does…
TheBoyan
  • 6,802
  • 3
  • 45
  • 61
4
votes
1 answer

full text catalog rebuild vs full text index start full populaton

I have a two step job running periodically in SQL Server 2012. ALTER FULLTEXT CATALOG [CatalogName] REBUILD ALTER FULLTEXT INDEX ON [tblname] START FULL POPULATION I didn't get the purpose of second step because google says that on first step…
Tanu Jain
  • 107
  • 1
  • 3
  • 11
3
votes
0 answers

C#: Create Index For An Attribute In Embedded Document

I have following document in my MongoDB database: { "_id":1, "user_name":"John Doe", "addresses":[ { "_id":null, "geolocation":null, "city":"Toronto" }, { "_id":null, …
Samsul Hoque
  • 53
  • 1
  • 7
3
votes
3 answers

Create Fulltext index on decimal/number coloumn, possible????? (SQL Server 2008)

I'd like to create a fulltext index on several columns which are varchars and numbers. And there is the problem with the numbers. Is there really no way to add column as number or decimal for the fulltext index? I've got for example a table…
robert
  • 31
  • 2
3
votes
0 answers

how to fulltext index both chinese and english characters together by using ngram parser in mysql 5.7?

I have a table named 'comp' with a column 'compName', the compName contain different country's Characters, I am using mysql5.7 with ngram parser, now it is fine to search the Chinese word, but the it brings me the bad result when i searched English…
Kris
  • 151
  • 1
  • 2
  • 12
1
2 3
…
8 9