indexing for full-text search
Questions tagged [full-text-indexing]
569 questions
3
votes
0 answers
Setting collation of full text index on SQL Server 2014 to distinguish 'ss' and 'ß'
I want to distinguish 'ss' and 'ß' within the full text indexing respectively quering the dynamic management functions of the full text index (sys.dm_fts_index_keywords and sys.dm_fts_index_keywords_by_document), but I can only choose the language…
mark
- 39
- 2
3
votes
1 answer
Exclude some text fields in MongoDB text index
I have a collection that has a text index like this:
db.mycollection.createIndex({ "$**" : "text"},{ "name" : "AllTextIndex"}))
The collection's documents have many text data blocks. I want to exclude some of them in order to not get results that…
3
votes
1 answer
Neo4j auto-index, legacy index and label schema: differences for a relative-to-a-node full-text search
this question is partially answered in
neo4j-legacy-indexes-and-auto-index-vs-new-label-bases-schema-indexes
and
the-difference-between-legacy-indexing-auto-indexing-and-the-new-indexing-approach
I can't comment on them yet and write a new thread…
user305883
- 1,635
- 2
- 24
- 48
3
votes
0 answers
mysql fulltext query is very slow
I have one table for User detail in MySql with about 500000 records in it. I have also created fulltext index on firstname, lastname field on this table. but when I am trying to search any single latter/alphabet (e.g. a to z, single character), it…
Manish Sapkal
- 5,591
- 8
- 45
- 74
3
votes
1 answer
What should the itemcount property in SQL Server match
If the itemcount property does not exactly match the number of indexed rows is that a problem? Is there a numerical way I can ensure that I have a complete full-text-index?
update: the property fulltextcatalogproperty('database','itemcount') does…
Judson
- 35
- 5
3
votes
2 answers
adding FULLTEXT index : didn't make much difference , is it going to index older data?
i have a query which is using a like condition and it's killing my server
(this query is what i get frequently in the slow-query-log )
btw my table has about 120k rows - pleas ignor the syntax errors
select * from `images` where `category`…
max
- 3,614
- 9
- 59
- 107
3
votes
1 answer
Possible to use fulltext indexes with views in SQL Server?
Is it possible to use FULLTEXT indexing with a view in Sql Server without creating the index on the view itself?
I was quite surprised to find that using CONTAINS(,) to query a column in a view doesn't work:
IF OBJECT_ID('ExampleTable') IS…
Cirdec
- 24,019
- 2
- 50
- 100
3
votes
3 answers
Compound FULLTEXT index in MySQL
I would like to make system whitch allows to search user messages, by specific user.
assume having folowing table
create table messages(
user_id int,
message nvarchar(500));
So what kind of index I should use here, if I want to search for all…
Bogdan Mart
- 460
- 8
- 19
3
votes
1 answer
FULL TEXT INDEX - Huge Performance Decrease on Multiple Tables
I've recently been learning something very new to me - FULLTEXT Indexes.
It seems that I can run off two separate queries (using CONTAINSTABLE) on the same parameters against two separate tables are gain an almost instantaneous answer (sub 10ms)…
Jon Bellamy
- 3,333
- 20
- 23
3
votes
2 answers
Search for ampersand (&) when using containstable in MS SQL Server
I'm using a stored procedure on a autocomplete dropdownlist to retreive a list of clients. Some of the clients have an '&' (ampersand) sign in the name e.g. 'H&M', 'Marks & Spencers' and users would like to search on the '&' sign.
When i directly…
K-M
- 660
- 3
- 13
- 27
3
votes
0 answers
How to pass a custom analyzer to @Indexed annotation?
Neo4J lets us provide a custom Analyzer when creating indexes.
How can we achieve this with Spring-Data-Neo4j? Since @Indexed doesn't have this property, what are other options?
SelimOber
- 708
- 6
- 17
3
votes
2 answers
How to refresh a full text index from within a SQL Server transaction
I am having an issue similar to the one described here:
How do I force a refresh of a fulltext index within a transaction in mssql?
However, the recommended solution posted there does not work. I tried posting a follow up to the same thread, but it…
Chris
- 81
- 1
- 8
3
votes
1 answer
Can IFilters 2.0 full-text index the text in a chart in an Office 2007 document?
I have a full-text catalog containing PowerPoint presentations. Some of those presentations contain charts, and in those cases, the chart is usually the main thing on the slide. When doing a search, I therefore want to be able to search for the text…
Gary McGill
- 26,400
- 25
- 118
- 202
3
votes
1 answer
How to ignore noiseXXX.txt files for a specific column in SQL Server 2005?
I have a product table where the description column is fulltext indexed.
The problem is, users frequently search a single word, which happens to be in the noiseXXX.txt files.
We'd like to keep the noise word functionality enabled, but is there…
John MacIntyre
- 12,910
- 13
- 67
- 106
2
votes
1 answer
creating a lucene index to find parent based on data of children
I am trying to understand how to build a lucene index for data that has a 1 to many relation.
suppose I have a table for families with id and family name
and a table of people with id, first name, and hobbies (which is free text).
how would I…
epeleg
- 10,347
- 17
- 101
- 151