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.
3
votes
1answer
745 views
Postgres full text search with multiple columns, why concat in index and not at runtime?
I've come across full text search in postgres in the last few days, and I am a little confused about indexing when searching across multiple columns.
The postgres docs talk about creating a ts_vector ...
1
vote
1answer
587 views
At which frequency run CTXSYS.CTX_DDL.OPTIMIZE_INDEX(…) on a fulltext index?
I've been told to run periodically CTXSYS.CTX_DDL.OPTIMIZE_INDEX(...) on some fulltext indexes, with no more information, in particular at which frequency this task should be run.
I guess that it ...
2
votes
1answer
100 views
General strategy for updating a full text search index
I am using a SQL Server 2008 R2 DB with FTS enabled on it. I applied an FTS index on a table. The table is frequently updated (I mean the CUD operations). Keeping this in mind, I came up with a ...
4
votes
1answer
260 views
Full-text index in partitioned table
I have a table with just over a million records with a full-text index.
This table has been split in two in the past, and the data older than a certain date is moved to another table with the exact ...
2
votes
1answer
152 views
Building a custom database in C with/without SQL? [closed]
Provide link or tutorials to build a custom database management in C. I am looking for Full Text Search options of about 10GB DB.
1
vote
0answers
168 views
Full Text Search with Encryption SQL Vs NoSQL? [closed]
Can any tell Which will be better for online and offline projects
4
votes
2answers
3k views
How to set full text catalog location SQL Server 2008/2012
I want to upgrade my SQL Server 2005 database to SQL Server 2012. In SQL Server 2005 you can set the location of the full text catalog when you create it. But in SQL Server 2012 (and in SQL Server ...
0
votes
1answer
91 views
Where I can find articles or resources explain MySQL Fulltext index? [closed]
I want to understand MySQL index and Fulltext index. Where can I find resources to help me understand it? Or can you help understand MySQL indexing mechanism?
3
votes
2answers
4k views
Why does simple ALTER TABLE command take so long on table with full-text index?
I have a large (~67 million rows) name-value table that has full-text indexing on the value column (DataValue).
My question is:
If I try to run the following sql command:
ALTER TABLE VisitorData ...
1
vote
1answer
676 views
SQL Server 2008 R2 Most Efficient Full Text Search Field Type
In SQL Server 2008 R2, what is the most efficient column type to store data enabling full text search?
I can currently see two options, nvarchar and varbinary.
Which one performs better and why?
...
4
votes
1answer
219 views
Can Oracle Text query return the terms found?
I am querying an Oracle 10g database. The database contains a table with documents that has an oracle text index. I query the database using a query like
SELECT SCORE(1), title from news WHERE ...
4
votes
1answer
646 views
Alternatives to LIKE and FTS for mid name search
I have a question about what are the alternatives for LIKE '%%' and Full-Text Search when it comes to searching organisation names, firstnames, surnames, etc.
The LIKE '%%' causes table scan, however ...
2
votes
2answers
271 views
MySQL Full Text index issue
I Have a table articles with following data
mysql> select * from articles;
+----+-----------------------+------------------------------------------+
| id | title | body ...
1
vote
1answer
204 views
MySQL full text search ranking
I found in this article the formula that MySQL use to ranking in FTS
w = (log(dtf)+1)/sumdtf * U/(1+0.0115*U) * log((N-nf)/nf)
Where
dtf is the number of times the term appears in the ...
2
votes
1answer
413 views
Can I get similar Full Text Search functionality without using Full-Text Search?
Normally, I wouldn't post this kind of question here, but I can't seem to find anyone who has actually used SQL Server Full Text Search, so I'm posting here.
I'm creating a solution for a client that ...
3
votes
1answer
545 views
FULLTEXT index ignored in BOOLEAN MODE with 'number of words' conditional
fulltext match is ignoring its index when I add a number of words conditional for its boolean mode. The selects are as follows:
explain select * from seeds WHERE MATCH(text) AGAINST ("mount ...
2
votes
1answer
644 views
Are there disadvantages to using Full-Text Search in SQL Server?
Are there disadvantages to using Full-Text Search in SQL Server? Is there much of an increased CPU or memory load on the server?
1
vote
2answers
521 views
Is it better to use FREETEXT or CONTAINS Full Text Searches when searching by single characters
I am trying to come up with the most efficient way to search for records in a collection of about 130,000 total records. The long, short of it is we have about 130,000 Active Directory records. I am ...
4
votes
1answer
837 views
Where are Full-Text indexes in SSMS 2008 R2
I created a new database, a few tables, and full-text index & catalog using SQL Server Management Studio without any problem. I wanted to copy the T-SQL creation scripts for each of those to ...
2
votes
2answers
261 views
What does “GIN doesn't support full index scans” mean?
I'm a RDBMS newbie and I have a PostgreSQL database of more than 50 millions lines, growing everyday. There is a column 'text', which contains human-generated text of around 20 words. I need to be ...
5
votes
1answer
720 views
SQL Server 2008 Containstable generate negative rank with weighted_term
I have a table with full text search enabled on Title column. I try to make a weighted search with a containstable but i get an Arithmetic overflow for the Rank value. The query is as follow
SELECT ...
2
votes
2answers
565 views
SQL 2008, how does it link Full Text Catalog to a filegroup
While creating Full Text Catalog, if "on filegroup" is specified - it creates the catalog on this file, but on MSDN I read "On Filegroup" clause has no affect?
3
votes
2answers
386 views
ts_rank massively slows my query, how can I improve performance?
Here's the table definition
Table "public.kb_article_contents"
Column | Type | Modifiers
------------+----------+-----------
article_id | smallint | not null
contents | text | not ...
3
votes
1answer
327 views
Mysql fulltext boolean ignore phrase
I'm trying to come up with a mysql boolean search that matches "monkey" but ignores / doesn't take into account any matches of "monkey business".
Something like the following is the general idea but ...
2
votes
2answers
330 views
Should SQL full text search match the value test2 when searching for test?
if i have table data that is indexed using full text search in Microsoft SQL server 2005 that includes raw table data such as "test2" should a query using FTS find a match if the search string is ...
2
votes
1answer
220 views
Why doesn't FTS match any records?
I created an indexed view with a few fields that i created a full text search based on these fields.
here is my view:
alter VIEW vFullTextSearch
WITH SCHEMABINDING
AS
SELECT M.Id as MessageId, ...
1
vote
2answers
229 views
create a FTS in sql2005 on multile fields in multiple tables?
How can I create a Full Text Search catalog on 3 fields where one is in a second table?
5
votes
1answer
1k views
How to install SQL Server Express 2005 with Full text search
I am in need to Install SQL server 2005 Express edition with Full Text Search capability. I don't know what to download and the order of installing the Database management system. Could someone ...
3
votes
1answer
320 views
How to get the Oracle Text Index's underlying Virtual XML Document?
The Oracle Text Reference 10g states that when we index our table using multi-column datastore, the system concatenates the text columns, tagging the column text, and indexes the text as a virtual XML ...
