Get Compound Index Patterns

Identify compound index opportunities.

Finds metadata fields commonly used together in filters, suggesting opportunities for compound (multi-field) indexes.

Use Cases:

• Optimize multi-field queries
• Create compound indexes
• Understand query complexity
• Improve complex filter performance

Response Includes:

• Field combinations used together
• Frequency of combination usage
• Average and P95 latency
• Sorted by combination frequency

Compound Index Example: If brand + status appears frequently, create:

db.documents.createIndex({"metadata.brand": 1, "metadata.status": 1})

Example:

curl -X GET "https://api.mixpeek.com/v1/analytics/namespaces/indexes/compound-patterns" \
  -H "Authorization: Bearer YOUR_API_KEY" \
  -H "X-Namespace: your-namespace"