Searching the text of a collection of documents or free text fields in a database to find those containing a word or combination of words.

learn more… | top users | synonyms

0
votes
0answers
10 views

2008 R2 Express Silent Install - FullText Service Not working

I'm trying to build an installer for an app that installs SQL SERVER 2008 R2 ADV with FullText already enabled, but couldn't sort it out. It must support Windows XP, so that's the first OS I'm ...
0
votes
0answers
21 views

SQL SERVER 2012 Express - Can't change Thesaurus Location

I have a requirement for an application to change the location where SQL SERVER looks for the Global Thesaurus file. According to the official documentation: "You can change the location and names ...
5
votes
1answer
56 views

Full Text Search Term Casing Affects Results

I have been experiencing a full text problem when searching using CONTAINS. I have the full text catalog accent sensitive setting set to false. The table contains following rows: Microsoft C# ...
0
votes
0answers
35 views

How can I decrease FULLTEXT initialization time?

I'm trying to decrease execution time of the a query. Using SHOW PROFILE, FULLTEXT initialization takes about 0.3, which is too high. Other values are at normal level. How can I decrease FULLTEXT ...
1
vote
0answers
29 views

postgres - generating documents for full text search taking forever and eating up disk space

We use PostgreSQL and Django-Haystack with Elasticsearch for search on our service, and were thinking of switching to Postgres's built in full text search because of various annoyances using a NoSQL ...
1
vote
0answers
50 views

MySQL fulltext selection performance

I have 1.5M rows in a table. Following is the table create code: CREATE TABLE `jobs` ( `id` INT(8) NOT NULL AUTO_INCREMENT, `job_id` VARCHAR(50) NOT NULL DEFAULT '', `title` VARCHAR(255) ...
0
votes
0answers
20 views

full text index not being updated

I have a table that has a full text index defined on it. Change tracking is set to 'Automatic' but I can see that 'Table Full-Text Pending Changes' is set to '58429', and recently added rows (for the ...
0
votes
1answer
29 views

Mixed search in multiple columns

I have a table which has a particular column of type JSON, where some user's contact information are stored. I can alter the table and add new columns with cached values to increase search performance ...
1
vote
1answer
27 views

Troubleshooting vanishing fulltext index in SQL Server 2012

I am trying to get to the bottom of some weirdness. Yesterday I enabled a fulltext index on a table in SQL Server 2012 running on one of our LAN servers. I used the Wizard and set the index to update ...
0
votes
0answers
26 views

Simple full text search on 5000 rows is very slow

I am running this full text search on an indexed view and it is taking 20 seconds to query across 5000 rows and return 0 rows. I believe it has something to with the forward slashes because all other ...
0
votes
1answer
16 views

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 ...
1
vote
1answer
95 views

Does SQL Server 2014 Express, with Advanced Services, actually support full text search?

I've installed SQL Server 2014 Express edition, with advanced services. I was hoping to try out the full-text search features. I read here that full text search is supported by the 2014 express ...
-1
votes
3answers
71 views

Full table scan even after adding index

i have two tables in Oracle 11g server one is partitioned and another is having a 3GB of data. I've added a composite index on both the tables based on the where clause, in the order it appears. The ...
0
votes
2answers
71 views

Full Text Catalog not populating

I just created a full text catalog : Enable full text (right click on db => file => enable ful text indexing) Create catalog (Storage => Fulle text Catalog => New Catalog => "FTCatalog" => OK) Add ...
0
votes
0answers
47 views

What is a good database design (schema) for an article search engine application?

I'm trying to make a article search engine application. There are about 1 million articles that will be stored in the DB. I've tried looking around for some similar examples, but I couldn't find any ...
0
votes
2answers
68 views

Using wildcards in NEAR in a Full Text Search

Let's say I have the following text somewhere in a document stored in an FT indexed table in SQL Server minsitry of education and science I want the query to ensure the words are NEAR, but the ...
1
vote
0answers
36 views

Manual Fulltext index population time in SQL Server 2012

I would like to know if there is a way to see how much time did it take SQL Server 2012 to index all the data in a table? In my example I create the table, create the index and set the population to ...
1
vote
0answers
56 views

CONTAINS does not work with ROW_NUMBER

I have the following query: SELECT RowNumber = ROW_NUMBER() OVER (ORDER BY ID DESC) , ID , Name FROM Clients WHERE CONTAINS (Name, 'Jose') My client table has a single ...
0
votes
0answers
23 views

Searching larger documents

I'm currently developing an application where I want to use MongoDB for the main database. I'm trying to store the emails metadata inside the database. My schema: user_id (integer 32bit) -- index ...
1
vote
1answer
30 views

capability and performance of tags implemented as array vs text vs full text

In terms of search capability and performance, what are the pros & cons of implementing tags as an array or text or full text field? I am seeing limitations of capability in choosing to implement ...
0
votes
0answers
41 views

Strange behavior with context index on matarialized view

We are experiencing a very strange behavior with a materialized view on oracle. Here is the statement that we've used to create the materialized view: CREATE MATERIALIZED VIEW MY_MATERIALIZED_VIEW ...
0
votes
1answer
142 views

Keyword Search a single SQL Server table for multiple search terms and create a new table from results?

I am not a database administrator. Most of my experience is with MySQL. However I think what I want to do is in the realm of possibility. I want to text query a single large table in a SQL Server ...
0
votes
1answer
33 views

How to find the rows from a table which has exactly two 'n' s in the employee name?

I want to find all the employees whose names have exactly two n's in their name. How can this be done?
1
vote
1answer
64 views

Full text index search returns an unexpected result

When I search TaxIdentityNumber using contains an unexpected result is returned; the result contains numbers that are not matched to query. For example, I search using '"5689523657*"' and get ...
1
vote
1answer
64 views

Modeling a db that has products: What are the good practices/solutions? How to treat grammar variations in the words?

The problem is: A Company belongs to a sector. A Company produces products. A Sector contains products. A Product belongs to sectors. Three entities: Company, Sector and Product. And it's a ...
2
votes
1answer
140 views

How to search double quotes in fulltext search in sql

I have double quotes in my Keyword. How can I search this in my fulltext search query. I have this query SELECT top 10 K.[KEY], 10, K.[RANK] FROM CONTAINSTABLE(ProductKeywords, Keywords, '("19*") ...
1
vote
1answer
107 views

DTC Timeout when trying to update oracle table through link that contains a text index

Problem Given is a SQL Server connected to an ORACLE Instance as a Linked Server. It’s using the Oracle Client OLEDB Provider. When doing an update in a transaction on a table having a CTXSYS.CONTEXT ...
0
votes
0answers
4 views

Specification for Item Advanced Search API

Does anyone know where I can find the specification for the Item Advanced Search API, that is mentioned here? http://docs.oracle.com/cd/E26401_01/doc.122/e48837/T381848T381419.htm#egoug_advsrchAPI
0
votes
0answers
52 views

Elasticsearch and product characteristics

I have a small question about elasticsearch. Let's say I have a database with products to sell, like an ecommerce. I know that elasticsearch can help me to find the best product with, for instance a ...
1
vote
1answer
132 views

MongoDB text index and text search

I have a mongodb collection db.articles,it has 2 keys ,"title" and "abstract".I want to do text search on these two keys.For example, the search text is "physics",and I want all the documents whose ...
0
votes
2answers
118 views

DBI1011I Error when using db2iupdt to enable Text Search

I'm trying to enable Text Search in my DB2 instance. I'm running this command: # /opt/ibm/db2/V10.5/instance/db2iupdt db2inst1 -j "TEXT_SEARCH,db2j_db2inst1,55000" I get this error: DBI1011I An ...
1
vote
1answer
35 views

Rebuild the Fulltextcatalog

I have a Database (80GB) that is able to store attachments. These attachments are full text indexed. For some reasons I had to rebuild the fulltext catalog and this 30 hours. Our business users ...
0
votes
1answer
89 views

What is the best partition technique for large table with TEXT column?

MySQL: What is the best partition technique for large InnoDB table (around 1.5M rows) with TEXT type of column? There is a FULLTEXT index on the TEXT column, which is very essential for my searching ...
0
votes
0answers
170 views

MySQL Pre-Filter Subquery

Good Evening All, I'm trying to pre-filter a table such that the more complex MATCH ... AGAINST query doesn't need to process every row in the DB. I tried obtaining a list of identifiers (query 3) ...
1
vote
0answers
51 views

SQL Server Full-Text Index with Stoplist

I've searched this site and the internet in general and can't find any information which answers my question, so I thought I'd post it here. I have Full Text search operating on a database in SQL ...
5
votes
1answer
281 views

SQL Server Full Text Search - .rtf files incorrectly indexed by rtf tags

I've set up a full-text index on my SQL Server DB on a varbinary(max) column. I have a type column specified, which contains the extension of the file, such a ".doc", ".pdf" etc. However, I have ...
0
votes
0answers
26 views

Bring relevant results based on an input search query - full text search?

The database contains information about businesses : title,name, categories, services, description ... to bring the relevant businesses to the user according to his search query I'm thinking about ...
0
votes
2answers
260 views

How do I use an Ispell dictionary with Postgres text search?

Postgres can use Ispell-compatible dictionaries in text search, but does not provide the required files.
0
votes
1answer
277 views

PostgreSQL FTS and Trigram-similarity Query Optimization

I have recently started working on PostgreSQL and I have around 12M rows to handle in which I want to apply Full Text Search. I don't have any prior experience in handling such databases. I have tried ...
-2
votes
2answers
125 views

SQL Server 2012 - Stopword Error [closed]

I am doing an exercise in Microsoft 70-461 certification book (written by Itzik Ben-Gan) In chapter 6-Query Full text data. I run the following query to create a stopword list. The system showed me ...
1
vote
1answer
256 views

Prefix full text search with numbers in SQL Server

If I create the following table in SQL Server 2008 R2: CREATE TABLE test( id BIGINT IDENTITY NOT NULL, value VARCHAR(10), CONSTRAINT test_pk PRIMARY KEY (id) ); CREATE FULLTEXT CATALOG ...
1
vote
1answer
146 views

Language difference in full text search for numeric strings

If I create this table on SQL Server 10.50.2550 (SQL Server 2008 R2): CREATE TABLE test( id BIGINT IDENTITY NOT NULL, number VARCHAR(10), CONSTRAINT test_pk PRIMARY KEY (id) ); CREATE FULLTEXT ...
1
vote
1answer
490 views

MySQL Regex matching newline or end of string

I have a text column in mysql which contains some values separated by a newline. I want now to query by these values and thought a regex should help me with that by doing something like: SELECT * ...
1
vote
1answer
240 views

SQL Server Full-Text Search: combining proximity term and thesaurus

Scenario I am developing a full-text search over a products table. The full-text indexed field of th table contains a brief description of the product, the name of the category and the product code. ...
0
votes
0answers
158 views

fulltext search on multiple tables with different fields

I am trying to make a search page return results from multiple table ordered by the keyword. The problem is the select statement gives a result sorted by the select statement and not by the keyword. ...
0
votes
0answers
29 views

ALTER FULLTEXT STOPLIST How to add newline char to stoplist?

ALTER FULLTEXT STOPLIST How to add newline char to stoplist in sql 2008 and 2012
0
votes
0answers
44 views

Oracle Text - Index an XML Documents Markup

Is there a way to get Oracle Text to index an XML document's mark up and not just element's PCDATA? I have a requirement to allow users to text search a whole XML document, mark up included, but I ...
1
vote
1answer
152 views

How to repair all indexes in a MySQL database?

My database got corrupted, and now the php app is throwing this error: Invalid query: Can't find FULLTEXT index matching the column list The error is not very useful, since it doesn't say what ...
1
vote
2answers
130 views

to use full text search or not?

In my web app, I have a web page for admins that displays the following fields: user id (numeric) device id(numeric) device description (text) cell phone number (text) user name (string ... but ...
1
vote
1answer
1k views

mysql match against boolean mode

I'm using MATCH AGAINST in boolean mode to add a simple search functionality to my site. The column to be searched is varchar, with no full text index. The column value can be alphanumeric, all ...