Index Creation for Optimized Queries

Show how to create efficient indexes in MongoDB for common query patterns in a RAG (Red, Amber, Green) status data model to speed up read operations.
// Connect to the MongoDB client
const MongoClient = require('mongodb').MongoClient;
const uri = 'your-mongodb-uri';
const client = new MongoClient(uri, { useNewUrlParser: true, useUnifiedTopology: true });

// Database and collection
const dbName = 'yourDatabaseName';
const collectionName = 'ragStatusData';

client.connect(err => {
  if (err) throw err;
  const db = client.db(dbName);
  const collection = db.collection(collectionName);

  // Create an index for the 'status' field
  collection.createIndex({ 'status': 1 }, { background: true }, (indexErr, result) => {
    if (indexErr) throw indexErr;
    console.log(`Index created: ${result}`);
The JavaScript code snippet connects to a MongoDB database instance and creates an ascending index on the 'status' field of the 'ragStatusData' collection to optimize queries filtering by status, which is common in a Red, Amber, Green (RAG) status data model. The index is created in the background for minimal impact on the database's performance.