Waɗanda ƙwallafan ƙirar fihiristi (indexing strategies) MongoDB ke goda?

Question

Accepted Answer

Waje da ƙirar fihiristi na gida daya, MongoDB yana ba da ƙwallafan ƙirar fihiristi — **ṭarƙar fihiristi mai launi (ESR rule)**, **tambayoyin da aka rufe**, **fihiristi mai ɓoye/karamar yawan jiya**, **TTL fihiristi**, da ƙari — waɗanda ke canza aikin tambaya sosai. Ilmantar da su shine maɓalli na gida na inganta MongoDB a girma.

## Ƙa ESR don fihiristi mai launi

```text
For a compound index supporting a query with Equality, Sort, and Range conditions,
order the fields: EQUALITY → SORT → RANGE (the ESR rule).
```

```js
// query: status = "active" (equality), sort by date (sort), age > 21 (range)
db.users.createIndex({ status: 1, date: 1, age: 1 });   // E, S, R order
db.users.find({ status: "active", age: { $gt: 21 } }).sort({ date: 1 });
// → the index serves equality match, sorted output, and range scan efficiently
```

**Ƙa ESR** (Daidaita, Tsara, Jiya na filin keɓe) yana gina fihiristi mai launi waɗanda ke ba da aiki ga tsattsauran tambaya, tsara, da filin keɓe cikin karfi — babbar ƙwallafar inganta.

## Tambayoyin da aka rufe — ba da aiki gida daga fihiristi

```js
// if a query's filter AND returned fields are ALL in the index, no document fetch needed
db.users.createIndex({ email: 1, name: 1 });
db.users.find({ email: "ann@x.com" }, { name: 1, _id: 0 });  // COVERED
// → answered entirely from the index (very fast — never touches the documents)
```

**Tambaya da aka rufe** (duk tsatsauran da yanar tukawa ba jiya gida) ana amsa daga fihiristi kainai — saurin gaske, babu karanta jijiyoyi.

## Nau'ikan fihiristi na musamman

```text
PARTIAL  → index only documents matching a filter (smaller, targeted)
  createIndex({ email: 1 }, { partialFilterExpression: { active: true } })
SPARSE   → index only documents that HAVE the field (skip missing)
TTL      → auto-delete documents after a time (sessions, logs, temp data)
  createIndex({ createdAt: 1 }, { expireAfterSeconds: 3600 })
UNIQUE   → enforce uniqueness (can combine with partial)
MULTIKEY → automatic for array fields (indexes each element)
WILDCARD → index unknown/arbitrary field names ({ "$**": 1 })
HASHED   → for hashed sharding / even distribution
```

## Nazarin da kula da fihiristi

```text
✓ explain("executionStats") → verify index use (IXSCAN), check docs examined vs returned
✓ $indexStats → find UNUSED indexes (remove them — they slow writes for no benefit)
✓ Atlas Performance Advisor → suggests indexes based on actual query patterns
✓ Balance: enough indexes for reads, not so many that writes suffer
```

## Me ya sa hakan ya makara

Kwallafan ƙirar fihiristi masu karfi sune *ilmi mai daraja* don **inganta aikin MongoDB a girma**, gina akan ƙirar gida daya.

Halinai da ƙirar gida daya ta taimakon, kuma *ilmantar da kwallafan ƙirar jiya* ne ke raba dace daga kyau MongoDB inganta.

**Ƙa ESR** (tsara filayen fihiristi mai launi azaman Daidaita, Tsara, Keɓe) shine babbar ƙwallafar gina fihiristi mai launi waɗanda ke aikin da karfi ga ɗan tambaya filayen daidaita, tsara, da keɓe tare — inganta da ba ta yawun ba ta aiki. **Tambayoyin da aka rufe** (inda duk tsatsauran da jijiyoyi da aka dawo suke jiya gida, don tambaya ana amsa daga fihiristi kainai ba tare da karanta jijiyoyi) sune murbushi mai girma wajen karatu — ƙwallafar iko mai karfi.

Sanin **nau'ikan fihiristi na musamman** — **rufe** (fihirista jijiyoyi da suka dace, karama da ƙunshi), **karamar yawan jiya** (jijiyoyi kawai tare da filayi), **TTL** (bayar jiya ta atomatik, kyau don saɓi/rubuce/bayyan bayyan), **wildcard** (don ba'a sanin sunaye filayi), **multikey** (atomatik don jerin jiyoyi), da **na musamman** — yana ba ka damar zaɓar fihirista daidai ga kowane yanayin, inganta ajiyawa da karɓar kuɗi wajen tsarawa.

**Nazarin da kula** (amfani da `explain()` don tabbatar da amfani da fihirista da karfi, `$indexStats` don nemi da cire fihiristi da ba a amfani, waɗanda ke ralewa a tsarawa, da kayan aiki irin Atlas Performance Advisor) shine mahimman adalci don kiyaye fihirista ta aiki lokacin da lokaci ya wuce.

Tunda fihiristi shine babbar tsofon inganta MongoDB, kuma tunda kwallafan ƙirar jiya (ESR tsara mai launi, tambayoyin da aka rufe, nau'ikan fihiristi na musamman, da kula) ne ke inganta ta girma, ilmantar da kwallafan ƙirar fihiristi masu karfi shine *ilmi mai daraja* don MongoDB mai aikin gaske, jigon labarin inganta ya bayyana ilmantar da babbar karfi, da waje inda ƙwallafan irin ESR rule da tambayoyin da aka rufe sune murbushi mai girma, aiki mai mahimmanci inganta.