Robuta

A secondary index of a HALDB database must be a HALDB partitioned secondary index (PSINDEX).

Create wildcard indexes to support queries on arbitrary or unknown fields in collections with flexible schemas.

Details on when and how to use text indexes in a self-managed or on-prem MongoDB database.

TTL indexes are special single-field indexes for automatically removing documents from a collection after a certain amount of time or at a specific clock time.

Use a unique index to ensure indexed fields do not store duplicate values.

Learn how you can optimize a slow database query in your application with a B-Tree index using Prisma

Create sparse indexes in MongoDB to include only documents with the indexed field, skipping those without. Use partial indexes for greater control.

You can restrict BMP, JBP, and batch-processing applications programs to a subset of one or more contiguous partitions of a HALDB partitioned secondary index...

You do the database optimization manually by running your own custom script via the SQL Server Agent.

Indexes can be easy. I promise.

Improve query performance for time series collections by adding secondary indexes, including compound indexes on `metaField` and `timeField`.

Learn how to create and use partial indexes in MongoDB to optimize storage and performance by indexing only documents that meet specific filter criteria.

When a secondary index is inserted, deleted or replaced, it is locked with a root segment lock.