Stack Overflow
Stack Overflow

Questions tagged [full-text-indexing]

indexing for full-text search

569 questions
13
votes
1 answer

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 problem is that I don't know how to create my Full-Text Index. When I use the Full-Text Indexing Wizard I get this error. A unique column must be…
gulbaek
  • 2,481
  • 13
  • 44
  • 65
13
votes
1 answer

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 spread over two tables that are combined by a procedure that the indexer calls at runtime (functional index). When I run…
Stefan
  • 3,382
  • 4
  • 23
  • 27
13
votes
1 answer

Create fulltext index within Entity Framework Coded Migrations

TLDR; How do you add a full text index using Entity framework 5 coded migrations I'm having issues adding a full text index to a database using Entity framework migrations. It needs to be there from the start so I'm attempting modifying the…
Tom Riley
  • 1,701
  • 2
  • 21
  • 43
12
votes
2 answers

List which columns have a full-text index in SQL Server 2005

How do I list all tables / columns in my database that have a full-text index?
Andreas Ågren
  • 3,879
  • 24
  • 33
12
votes
1 answer

Creating text index in pymongo

I have a database of English words stored in the field 'h'. I've just found out about text indexes and I wanna create one on this field to speed up searching by regex, but somehow, I just can't get the syntax right. I'm using pymongo 2.7.1 and…
thehousedude
  • 611
  • 6
  • 16
11
votes
3 answers

how does lucene calculate intersection of documents so fast?

What are the internals of storage and search that allow this? As in the nitty gritties? For example, I have a million documents matched by a term and a million others matched by a second term of an AND query. How does lucene do an intersection so…
Guy Sensei
  • 529
  • 3
  • 10
11
votes
4 answers

Oracle: Full text search with condition

I've created an Oracle Text index like the following: create index my_idx on my_table (text) indextype is ctxsys.context; And I can then do the following: select * from my_table where contains(text, '%blah%') > 0; But lets say we have a have…
Clinton
  • 22,361
  • 15
  • 67
  • 163
11
votes
2 answers

Problems creating a full text index on a view

I have a view which has been created like this: CREATE VIEW [dbo].[vwData] WITH SCHEMABINDING AS SELECT [DataField1] , [DataField2] , [DataField3] FROM dbo.tblData When I try to create a full text index on it,…
Tola Odejayi
  • 3,019
  • 9
  • 31
  • 46
10
votes
4 answers

How to add more OR searches with CONTAINS Brings Query to Crawl?

I have a simple query that relies on two full-text indexed tables, but it runs extremely slow when I have the CONTAINS combined with any additional OR search. As seen in the execution plan, the two full text searches crush the performance. If I…
scolja
  • 433
  • 4
  • 14
9
votes
3 answers

FTS doesn't work as expected with emails with dots

We're developing a search as a part of a bigger system. We have Microsoft SQL Server 2014 - 12.0.2000.8 (X64) Standard Edition (64-bit) with this setup: CREATE TABLE NewCompanies( [Id] [uniqueidentifier] NOT NULL, [Name] [nvarchar](400) NOT…
kseen
  • 359
  • 8
  • 56
  • 104
9
votes
3 answers

Neo4j free text search combined with relation query

I see that Neo4j have Indexes to support full-text search. But I can't find examples in the documentation on how to use this ability with regular relations query. For example, I have the following structure:…
Roee Gavirel
  • 18,955
  • 12
  • 67
  • 94
8
votes
3 answers

Build an index for substring search?

I want to do general substring search among billions of strings. The requirement is a little different from general fulltext search because I want a query "ubst" also can hit "substr". Is Lucene or Sphinx capable of doing this? If not, what's the…
Chen Xing
  • 1,665
  • 2
  • 13
  • 13
8
votes
1 answer

Elasticsearch index sharding explanation

I am trying to figure out the concept of elastic search index and quite don't understand it. I want to make a couple of points in advance. I understand how inverse document index works (mapping terms to document ids), I also understand how the…
Alex Pryiomka
  • 391
  • 3
  • 11
8
votes
1 answer

is it possible to use negative query boost in lucene?

I want to penalize some terms in query, not to ignore them at all so "MUST NOT" operator will not work? Is it possible to use negative query boost with SHOULD in boolean query in lucene, how does it work?
yura
  • 14,489
  • 21
  • 77
  • 126
8
votes
1 answer

How to improve detection of sentences in Sphinx?

It is possible to search words in one sentence with Sphinx. For example, we have next text: Вася молодец, съел огурец, т.к. проголодался. Такие дела. If I search молодец SENTENCE огурец i find this text. If I search молодец SENTENCE…
Nick
  • 9,735
  • 7
  • 59
  • 89
1
2
3
…
37 38