In MongoDB, you can create an index on a collection using the createIndex() method, the createIndexes() method, or the createIndexes administration command.
Tag: indexes
Create a Wildcard Index in MongoDB
There are several ways to create an index in MongoDB, and from MongoDB 4.2, we can create wildcard indexes.
A wildcard index can be thought of as a kind of filter that automatically matches any field, sub-document or array in a collection and then indexes those matches.
Continue readingList all Indexes in an SQLite Database
In this article I outline two ways to return a list of indexes in an SQLite database.
The first (and most obvious) method is to use the .indexes dot command. The second method is to query the sql_master table.