Question : I have the following table: (Create table statement) CREATE TABLE `phppos_people` ( `first_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, […]
Tag: full-text-search
SQL Server Full-text population deadlock
Question : I’ve created a full-text index on a non-persisted computed column in a table (details here). However, every couple […]
SQL Server: Collation of the resource database
Question : I’m trying to use stopwords so that some words are skipped by the Full-Text Indexer. I can add […]
PostgreSQL: Index Trigger / Hook? For Synonyms
Question : Is it possible, in PostgreSQL, to add a trigger to modify data prior to it going into a […]
MariaDB Full Text Index – How to query old data as well
Question : I have added new full text index to mariadb ALTER TABLE <table name> ADD FULLTEXT INDEX records I […]
Are there differences in performance of getting data between FullText Search and indexed columns
Question : In SQL Server 2008 R2 I have a query which looks like create stored procedure give_me_art @filter varchar(15),@skl_id […]
At which frequency run CTXSYS.CTX_DDL.OPTIMIZE_INDEX(…) on a fulltext index?
Question : I’ve been told to run periodically CTXSYS.CTX_DDL.OPTIMIZE_INDEX(…) on some fulltext indexes, with no more information, in particular at […]
List full text indexes in Oracle database
Question : Using SQL Server, it’s possible to execute a query that returns all the columns that contain a full […]
Full text catalog missing a keyword
Question : We have a full text catalog on one of our databases but one keyword does not work. e.g: […]
Mysql full text search with other indexed data
Question : After getting some mysql optimization advice in this question. Was able to get the performance to the acceptable […]