Stack Overflow
Stack Overflow

Questions tagged [full-text-indexing]

indexing for full-text search

569 questions
0
votes
1 answer

Entity Framework Code First, FullTextIndex & Inheritance

I'm currently working, with my team, on a project where we have a large SQL Server 2014 database with a lot of data. To increase performances, we chose to use FullTextIndex with EntityFramework by following this tutorial. We now have a problem for…
Atlasmaybe
  • 1,511
  • 11
  • 26
0
votes
0 answers

Configure connectionString to use SQL Server instead of SQL Server Express

Problem I have a webproject that uses Fulltext-search, that I imported to a new computer (virtual machine). I get a warning, when opening the website in Visual Studio, saying: "The Web project xxx requires SQL Server Express, which is not installed…
chmodder
  • 184
  • 1
  • 3
  • 17
0
votes
1 answer

SQL Full Text Index Contains

I am fairly new to SQL FTI and I am trying to perfect a search against a table with millions of different product items. If I pass a search such as this: select top 100 * from OMG_ProductFeeds.dbo.tbl_products where CONTAINS(ProductName,'"apple…
Giles Hunt
  • 521
  • 5
  • 21
0
votes
2 answers

How to do partial match in full-text search in SQL Server

I have a list of places, e.g "Auckland", "Wellington". My current implementation, won't return these rows if "Auck" or "Welli" is typed. I am using full-text search, (as there are 30 million rows), and using: CONTAINSTABLE([Table], [Field],…
williamsandonz
  • 15,864
  • 23
  • 100
  • 186
0
votes
1 answer

How does like query work with indexed table

I am working in Spring-java and mysql. I have to query the table of size 100k records. Table has say 10 columns. And In my sql select query I have to make like queries with %text% search on say 4 columns. Those 4 columns are varchar(200), having…
Naman Gala
  • 4,670
  • 1
  • 21
  • 55
0
votes
1 answer

SQL Server 2012 - Fulltext search on nvarchar field with SHA hashes returns nothing

I have a SQL table with 60 Million records with 2 columns: ID and Hash. ID is a incremental int PK. Hash is a nvarchar field with Index. I created a Fulltext index on the Hash field like this: CREATE FULLTEXT CATALOG hashes_catalog; GO CREATE…
Rila Nera
  • 49
  • 7
0
votes
1 answer

SQL SERVER FULL-TEXT INDEX, CONTAINS return empty

I got a issue about full index, any body can help me on this? 1) set up full text index CREATE FULLTEXT INDEX ON dbo.Companies(my table name) ( CompanyName(colum of my table) Language 0X0 ) KEY INDEX IX_Companies_CompanyAlias ON QuestionsDB WITH…
max
  • 3
  • 2
0
votes
1 answer

SQL Server CONTAINS and highlighting the matches

Contains() with FORMSOF() is great for trying to capture the user's intent while searching, but is there any way to highlight the matches. If I search for "said", it might return texts containing "says, say, spoke" etc. Is there a way a way I can…
Regular Jo
  • 5,190
  • 3
  • 25
  • 47
0
votes
1 answer

Fulltext search not working properly

I have pers table and applied combine fulltext index on (prenom, nom) fields. Below are data in that table. persID prenom nom (pers table) -------------------------------- 116 te te 117 te test test te Now, I tried to…
Jimit
  • 2,201
  • 7
  • 32
  • 66
0
votes
1 answer

I am using orientdb and doing indexing but my indexing engine is sBTree i want o change it to Lucene what to do?

I am using orientdb and doing indexing but my indexing engine is sBTree i want o change it to Lucene what to do? public static void main(String[] args) throws IOException { OrientGraph graph = null; try…
abi_pat
  • 572
  • 2
  • 12
  • 35
0
votes
1 answer

SQL Full Text Index search of partial keyword

I have the following query to search product codes. If @keyword is BAG-61 then I receive no results, but if I change @keyword to BAG-612 then I do receive a result. Why is that? Am I not supposed to get results with below query if only a partial…
Hieg
  • 1
  • 1
0
votes
1 answer

MySQL full text query across multiple columns

I have an issue that I'm confused about when using a full text search in MySQL. I'm running MySQL 5.1.67. Here is my simplified table: CREATE TABLE `contact_info` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `first_name` varchar(25) DEFAULT…
dbCarl
  • 127
  • 1
  • 7
0
votes
1 answer

Neo4j, Neography: Making search smarter

I had been using full-text-indexes to search through the neo4j graph database. But in case the user enters a wrong spelling or the query doesn't match any result. Is there a way to handle this or a did you mean kind of feature in such cases? Also…
red-devil
  • 1,064
  • 1
  • 20
  • 34
0
votes
1 answer

SQL freetext() not working on some columns

I have a table which contains 7 columns and I have created a full text index on the table. However I noticed that a search using freetext() does not return any rows on 2 of the columns Its returns rows on other columns. Here is my query select *…
Poornima Nayar
  • 33
  • 4
0
votes
0 answers

MySQL FullText search on string shorter than 3 chars returns no rows

I have a MySQL table with some addresses in it. Let's say I have the following 2 rows: "10 Fake Street" "101 Fake Street" I'm trying to use fulltext search with MATCH() AGAINST(). I have set ft_min_word_len to 1, rebooted the server and dropped and…
Egor
  • 1,622
  • 12
  • 26
1 2 3
…
37 38