DEV Community

MongoDB Multi-key Indexes Series' Articles

Back to Franck Pachot's Series
Where SQL joins struggle but MongoDB documents shine
franckpachot profile

Where SQL joins struggle but MongoDB documents shine

#mongodb #postgres #sql #database
5
Comments 7
9 min read
Oracle Multi-Value Index and ORDER BY Pagination queries
franckpachot profile

Oracle Multi-Value Index and ORDER BY Pagination queries

#mongodb #oracle #multivalue #oson
1
Comments
7 min read
PostgreSQL JSONB Indexing Limitations with B-Tree and GIN
franckpachot profile

PostgreSQL JSONB Indexing Limitations with B-Tree and GIN

#postgres #gin #btree #jsonb
17
Comments 2
8 min read
Index Only Scan on JSON Documents in MongoDB, with covering and multi-key indexes
Cover image for Index Only Scan on JSON Documents in MongoDB, with covering and multi-key indexes
franckpachot profile

Index Only Scan on JSON Documents in MongoDB, with covering and multi-key indexes

#database #index #webdev #programming
7
Comments
10 min read
Microsoft CosmosDB: RUM instead of GIN but same limitations on JSON paths
Cover image for Microsoft CosmosDB: RUM instead of GIN but same limitations on JSON paths
franckpachot profile

Microsoft CosmosDB: RUM instead of GIN but same limitations on JSON paths

#mongodb #postgres #document #database
Comments
15 min read
Amazon DocumentDB and multi-key indexing
franckpachot profile

Amazon DocumentDB and multi-key indexing

#mongodb #aws #documentdb #index
2
Comments
8 min read
Google Firestore with MongoDB compatibility - index limitations
Cover image for Google Firestore with MongoDB compatibility - index limitations
franckpachot profile

Google Firestore with MongoDB compatibility - index limitations

#mongodb #database #index #firestore
4
Comments
6 min read