Question : I’ve been told to run periodically CTXSYS.CTX_DDL.OPTIMIZE_INDEX(…) on some fulltext indexes, with no more information, in particular at […]
Tag: full-text-search
Why my index don’t update?
Question : I have created this index ORACLE/VIDEO# create index titolo_index 2 on titolo(titolo) 3 indextype is ctxsys.context 4 ONLINE […]
FTs catalog in SQL Server for multiple FT index
Question : I have created one catalog for FTS index, can the same catalog be used by by another table […]
MySQL indexing issue when trying to search for a part of a string/word
Question : What we’re running into: Engine: MySQL. We’ve been working on a filter where an user can search for […]
Full table scan even after adding index
Question : i have two tables in Oracle 11g server one is partitioned and another is having a 3GB of […]
FullTextSearch indexing/searching words with special characters
Question : I’m trying to query FullTextSearch indexed column for hashtags SELECT Bio FROM Users WHERE CONTAINS (Bio,’promoter’) SELECT Bio […]
FULLTEXT CONTAINS search returns no results in SQL SERVER 2014 with multiple search terms
Question : When I try to use multiple search terms in a CONTAINS clause I get no results. SELECT * […]
Does SQL Server 2014 Express, with Advanced Services, actually support full text search?
Question : I’ve installed SQL Server 2014 Express edition, with advanced services. I was hoping to try out the full-text […]
How can I return the full text of a document indexed in SQL Server Full-Text?
Question : I’m using SQL Server 2014 with FileTables to store a large number of documents in different formats. The […]
FreeTextTable – Query as a set operation vs. having to cursor
Question : Does anyone know if it is possible to join to a free text table to query for many […]