Articles by Tag #index
Browse our collection of articles on various topics related to IT technologies. Dive in and explore something new!
B-Tree for Equality, Sort, Range (indexing strategies in MongoDB)
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...
Document Expiration with TTL Indexes in MongoDB
Without TTL (manual delete job) With TTL (expireAfterSeconds index) Comparison (server metrics and...
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...
![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...
$elemMatch and Multi-Key Indexes
In the previous post, I used the following index on the daily views data, which is an array of...
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...
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...
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...
Sampling Without Index
I won't create any indexes for this post yet, but I can still filter efficiently to run a query in...
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...
$graphLookup (Connect By / Recursive Query)
In this series, I present various access patterns for a specific document model. These patterns are...
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...
Amazon DocumentDB and multi-key indexing
In previous posts, I discussed the limitations of MongoDB emulations on databases like Oracle and...
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...
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...
.hint() in MongoDB is different that SQL optimizer hints: they force indexes
MongoDB sits at the crossroads between SQL, where developers can write queries on a logical model...
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...
Postgres: Index Scans
Using an index to help improve query performance is common practice. An index is a structure...
"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...
index in Python
Buy Me a Coffee☕ *Memos for a string and byte string(bytes and bytearray) functions: My post...
Why Doesn't Oracle Multi-Value Index Optimize .sort() Like MongoDB Does With its Multi-Key Index?
Until recently, Oracle Database offered very limited options for creating inverted indexes, primarily...
Tuple in Python (2)
Buy Me a Coffee☕ *Memos: My post explains a tuple. My post explains the tuple with slicing and...
![[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 ...
Avoiding the Pitfalls of Duplicate Indexes in MySQL
Indexes are fundamental for MySQL optimization, making data retrieval faster and more efficient....
Find Index of Item in Python List
Learn how to find an item's index in a Python list using list.index(), enumerate, safe wrappers, and performance tips under 160 chars.
Which Clause(s) Matched?
This article is part of a series. Please see the complete series above. Here's our playground of the...