Top "Full-text-indexing" questions

indexing for full-text search

MongoDB Full and Partial Text Search

Env: MongoDB (3.2.0) with mongos Collection: users Text Index creation: BasicDBObject keys = new BasicDBObject(); keys.put("name","text"); BasicDBObject options = new …

mongodb mongodb-query aggregation-framework spring-data-mongodb full-text-indexing
Warning: A long semaphore wait

For the past 4 days I have had massive problems with my nightly updates, except for 1 night were it all went …

mysql sql innodb alter-table full-text-indexing
Will indexing improve varchar(max) query performance, and how to create index

Firstly, I should point out I don't have much knowledge on SQL Server indexes. My situation is that I have …

sql-server sql-server-2008 indexing full-text-indexing database-optimization
strpos() with multiple needles?

I am looking for a function like strpos() with two significant differences: To be able to accept multiple needles. I …

php full-text-search full-text-indexing strpos
How to define if rebuilding of the full text index has finished?

Got a requirement to rebuild mssql full-text index. Problem is - I need to know exactly when job is done. …

sql-server full-text-indexing
Speed up Oracle Text indexing or let the indexer work only on low load times

We're using a Oracle Text CTXSYS.CONTEXT index to index about half a million rows containing metainformation. The information is …

oracle full-text-indexing database-tuning
FullText search with CONTAINS on multiple columns and predicate - AND

I have a search table with, say, 4 columns of text data to search. I do something like this: SELECT * FROM …

tsql full-text-search full-text-indexing
Postgresql prefix wildcard for full text

I am trying to run a fulltext query using Postgresql that can cater for partial matches using wildcards. It seems …

sql postgresql full-text-search full-text-indexing
Enable Full-Text Search on View with Inner Join

I'm running Sql Server 2008 R2 and I need to enable Full-Text search on a view with a inner join. My …

sql sql-server-2008 full-text-search full-text-indexing
Faster search in Lucene - Is there a way to keep the whole index in RAM?

Is there a way of keeping the index in RAM instead of keeping it on the hard disk? We want …

search lucene full-text-indexing