Full-Text Searches in MySQL: The Good, the Bad and the Ugly
Sometimes when searching in a MySQL database you might want to run full-text search queries against character-based data. Today we’re discussing the advantages and disadvantages of such search methods. What are Full-Text Searches in MySQL?...
A Guide to MySQL Indexes
When MySQL query optimization is mentioned, indexes are one of the first things that get covered. Today, we will try to see why they are so important. What are Indexes? In general, an index is...
An Overview of Various Auxiliary Plan Nodes in PostgreSQL
All modern database system supports a Query Optimizer module to automatically identify the most efficient strategy for executing the SQL queries. The efficient strategy is called “Plan” and it is measured in terms of cost...
An Overview of the Various Scan Methods in PostgreSQL
In any of the relational databases engines, it is required to generate a best possible plan which corresponds to the execution of the query with least time and resources. Generally, all databases generate plans in...
PostgreSQL Index vs InnoDB Index – Understanding the Differences
Considering the current major use-case of a database as to retrieve data, it becomes very important that its performance is very high and It can only be achieved if data is fetched in the most...
Understanding MongoDB Indexes
Among the tasks involved in database management is improving performance by employing different strategies. Indexing is one of the tips that improve throughput operations by facilitating data access to query requests. It does so by...
An Overview of Database Indexing for MongoDB
What is Indexing? Indexing is an important concept in database world. Main advantage of creating index on any field is faster access of data . It optimizes the process of database searching and accessing. Consider...
Database Indexing in PostgreSQL
Database Indexing is the use of special data structures that aim at improving performance, by achieving direct access to data pages. A database index works like the index section of a printed book: by looking...
Webinar Replay: MySQL Query Tuning Part 2 – Indexing and EXPLAIN
We’ve just completed Part 2 of our webinar trilogy on MySQL Query Tuning this week and if you didn’t get the chance to join us for the live sessions (or would like to watch them...
An Overview of MySQL Database Indexing
An index is a data structure that sorts a number of records on one or more fields, and speeds up data retrieval. This is to avoid scanning through the disk blocks that a table spans,...