full-text search Tutorials, Tips & Tricks

1 Jun, 2012

Index usage with LIKE operator in Oracle & Domain Indexes

A lot of developers might be confused about index selectivity while using %LIKE% operator. So please find below how index worked when you use LIKE operator. Problem Statement While optimizing high CPU consuming queries on 3rd...

Full-Text Search using MySQL: Full-Text Search Capabilities

Database / MySQL

22 Apr, 2009

Full-Text Search using MySQL: Full-Text Search Capabilities

Have you ever thought how does the search functionality is implemented in all the websites! Most of the internet blogs and websites are powered by MySQL database. MySQL provides a wonderful way (Full-text Search)...