Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: full-text-search

multiple MYSQL full text indexing for innodb and memory + disk efficiency

By adminPosted on October 1, 2023

Question : I have the following table: (Create table statement) CREATE TABLE `phppos_people` ( `first_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, […]

SQL Server Full-text population deadlock

By adminPosted on September 30, 2023

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

By adminPosted on September 27, 2023

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

By adminPosted on September 3, 2023

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

By adminPosted on September 2, 2023

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

By adminPosted on September 1, 2023

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?

By adminPosted on August 31, 2023

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

By adminPosted on August 23, 2023

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

By adminPosted on August 23, 2023

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

By adminPosted on August 20, 2023

Question : After getting some mysql optimization advice in this question. Was able to get the performance to the acceptable […]

  • 1
  • 2
  • 3
  • …
  • 43

Recent Posts

  • Can we prevent table from update directly but allow update using trigger from another table?
  • Querying ‘random’ Oracle data via openquery in SQL Server returning the same data for multiple runs
  • The implications of lack on indexes on supporting a large production database
  • How to limit work_mem on PostgreSQL
  • Select max(pk) instead of sequence.nextval
  • Query detailing differences between rows for a large amount of data
  • How to combine `delete` and `insert` operations in one statement?
  • Slow SQL Server database on a specific server [duplicate]
  • How to model the relationship between these three tables
  • Error when migrating MySQL 8 to SQL Server 2019
  • multiple MYSQL full text indexing for innodb and memory + disk efficiency
  • Many-To-Many relationship between Students and heights (Is it necessary?)
  • What is the ideal composite index for this query?
  • hosting images on own database or 3rd party
  • Can’t start mongodb server using ‘sudo service mongod start’
  • sqlcmd new login/user
  • Log Reader replication agents are constantly restarting
  • NTFS filesystem fragmentation & other influence vs database files
  • How to set the grow rate of database in SQLserver
  • How to make a trigger that will compare input with a value of other table?

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding