Articles on indexing
MySQL for JSON: Generated Columns and Indexing
MySQL doesn't have a way to index JSON documents directly, but it has given us an alternative: generated columns. One thing t…

Indexing for full text search in PostgreSQL
Do you have textual content in PostgreSQL that you'd like to be able to search more effectively, but you're not sure you're r…

MongoDB Indexing Best Practices
Going “Best Practice” on any topic is an expansive statement. But, we will give it a go with some high level anti-patterns an…