Articles on indexing

MySQL for JSON: Generated Columns and 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…

Abdullah Alger
Abdullah Alger
Indexing for full text search in PostgreSQL

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…

Lisa Smith
Lisa Smith

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…

Jason McCay
Jason McCay