Articles by Tag #index
Browse our collection of articles on various topics related to IT technologies. Dive in and explore something new!
$elemMatch and Multi-Key Indexes
In the previous post, I used the following index on the daily views data, which is an array of...
B-Tree for Equality, Sort, Range
When creating an index, you don't need the full details of the queries it will serve, but the...
Comparing Execution Plans: MongoDB vs. Compatible APIs
MongoDB is the standard API for document databases, and some cloud providers have created services...
Search Index for Reporting
In the first post of this series, I've imported a sample dataset, and I'll show how adding a few...
Document Expiration with TTL Indexes in MongoDB
Without TTL (manual delete job) With TTL (expireAfterSeconds index) Comparison (server metrics and...
![Order-preserving or-expansion in MongoDB and $in:[,,] treated as a range skip scan, or exploded to an equality for the ESR rule](https://media2.dev.to/dynamic/image/width=1000,height=500,fit=cover,gravity=auto,format=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fflvc5nu43v2zfna1s49l.png)
Order-preserving or-expansion in MongoDB and $in:[,,] treated as a range skip scan, or exploded to an equality for the ESR rule
I concluded the previous post with a question. We have explored how queries with range and equality...
MongoDB TTL and Disk Storage
In a previous blog post, I explained how MongoDB TTL indexes work and their optimization to avoid...
Indexing for New Use Cases Within the MongoDB Document Model (tutorial)
When designing a schema for MongoDB, it’s crucial to understand your domain access patterns. The...
Index Only Scan on JSON Documents in MongoDB, with covering and multi-key indexes
Storing JSON documents in a SQL database does not make it a document database. The strength of any...
Sampling Without Index
I won't create any indexes for this post yet, but I can still filter efficiently to run a query in...
ESR (Equality, Sort, Range) rule applied to YugabyteDB and PostgreSQL indexes
TL;DR: To make developers' lives easier, MongoDB has documented a simple rule for creating an...
$graphLookup (Connect By / Recursive Query)
In this series, I present various access patterns for a specific document model. These patterns are...
Google Firestore with MongoDB compatibility - index limitations
In this series, I tested multiple MongoDB emulations on top of SQL databases, and all failed to be...
SQL Performance: A Deep Dive into Indexing with examples
Most of the times we create a single-column index for join columns, but in practical I experienced...
Amazon DocumentDB and multi-key indexing
In previous posts, I discussed the limitations of MongoDB emulations on databases like Oracle and...
Database: Indexing issues with random UUIDs
UUIDs are very popular among developers as the datatype for the identifier of a table. Database...
MongoDB With Search Indexes Queried as Kimball's Star Schema With Facts and Dimensions
Export From SQL to CSV Import to MongoDB Indexing the Star Schema Querying the Star Schema - Star...
Equality with Multiple Values, Preserving Sort for Pagination
In the previous post, I've created the following index to quickly find the last videos in one...
Sort on Array with Multi-Key Index
In the previous post, we discussed how MongoDB indexes retrieve documents ordered by a specific...
PostgreSQL partitioning with desired index names
Introduction A while back, Hetti wrote an article titled Indexing Partitioned Table...
No Index for LIKE on JSONB with Array in the Path (GIN limitation)
Here is an example where using PostgreSQL as a document database will quickly fail: indexing. Either...
![[Boost]](https://media2.dev.to/dynamic/image/width=1000,height=500,fit=cover,gravity=auto,format=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F7vt6lkars0qyheokpeaf.png)
[Boost]
B-Tree for Equality, Sort, Range Franck Pachot ・ May 23 ...
Tuple in Python (2)
Buy Me a Coffee☕ *Memos: My post explains a tuple. My post explains the tuple with slicing and...
Mastering MySQL Indexing: A Comprehensive Guide for Developers
Mastering MySQL Indexing: A Comprehensive Guide for Developers
Unleash Business Success: Master Employee Engagement, Market Research, and Customer Satisfaction with SurveyMars
Are you constantly grappling with the puzzle of how to improve employee engagement while also...
Variable Index Dynamic Average Multi-Tier Profit Trend Following Strategy
Overview This strategy is a trend-following system that combines the Variable Index Dynamic Moving...
"The API Is Slow, Fix It!" – What I Learned About `EXPLAIN` and Indexing
During a technical interview, the situation was something like this: “Your manager tells you: the...
Tried-and-True Methods to Immediately Get Google to Index Your Website
Does your website 98toto or page not receive any organic traffic? Do you want to know if Google is...
Avoiding the Pitfalls of Duplicate Indexes in MySQL
Indexes are fundamental for MySQL optimization, making data retrieval faster and more efficient....
Postgres: Index Scans
Using an index to help improve query performance is common practice. An index is a structure...