> ## Documentation Index > Fetch the complete documentation index at: https://docs.mixpeek.com/docs/llms.txt > Use this file to discover all available pages before exploring further. # 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: ```javascript db.documents.createIndex({"metadata.brand": 1, "metadata.status": 1}) ``` **Example:** ```bash curl -X GET "https://api.mixpeek.com/v1/analytics/namespaces/indexes/compound-patterns" \ -H "Authorization: Bearer YOUR_API_KEY" \ -H "X-Namespace: your-namespace" ``` ## OpenAPI ````yaml get /v1/analytics/namespaces/indexes/compound-patterns openapi: 3.1.0 info: title: Mixpeek API description: >- This is the Mixpeek API, providing access to various endpoints for data processing and retrieval. termsOfService: https://mixpeek.com/terms contact: name: Mixpeek Support url: https://mixpeek.com/contact email: info@mixpeek.com version: '0.82' servers: - url: https://api.mixpeek.com description: Production security: [] paths: /v1/analytics/namespaces/indexes/compound-patterns: get: tags: - Analytics - Analytics - Namespaces summary: Get Compound Index Patterns description: >- 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: ```javascript db.documents.createIndex({"metadata.brand": 1, "metadata.status": 1}) ``` **Example:** ```bash curl -X GET "https://api.mixpeek.com/v1/analytics/namespaces/indexes/compound-patterns" \ -H "Authorization: Bearer YOUR_API_KEY" \ -H "X-Namespace: your-namespace" ``` operationId: >- get_compound_index_patterns_v1_analytics_namespaces_indexes_compound_patterns_get parameters: - name: days in: query required: false schema: type: integer maximum: 90 minimum: 1 description: Days of history to analyze default: 30 title: Days description: Days of history to analyze - name: limit in: query required: false schema: type: integer maximum: 1000 minimum: 1 description: Maximum patterns to return default: 50 title: Limit description: Maximum patterns to return responses: '200': description: Successful Response content: application/json: schema: $ref: '#/components/schemas/CompoundIndexResponse' '400': description: Bad Request content: application/json: schema: $ref: '#/components/schemas/ErrorResponse' '401': description: Unauthorized content: application/json: schema: $ref: '#/components/schemas/ErrorResponse' '403': description: Forbidden content: application/json: schema: $ref: '#/components/schemas/ErrorResponse' '404': description: Not Found content: application/json: schema: $ref: '#/components/schemas/ErrorResponse' '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' '500': description: Internal Server Error content: application/json: schema: $ref: '#/components/schemas/ErrorResponse' components: schemas: CompoundIndexResponse: properties: namespace_id: type: string title: Namespace Id description: Namespace ID analyzed time_range_days: type: integer title: Time Range Days description: Number of days analyzed patterns: items: $ref: '#/components/schemas/CompoundIndexPattern' type: array title: Patterns description: Compound field patterns total_patterns: type: integer title: Total Patterns description: Total patterns found type: object required: - namespace_id - time_range_days - patterns - total_patterns title: CompoundIndexResponse description: Response for compound index patterns endpoint. ErrorResponse: properties: success: type: boolean title: Success description: Always false for error responses default: false status: type: integer title: Status description: HTTP status code for this error error: $ref: '#/components/schemas/ErrorDetail' description: Error details payload type: object required: - status - error title: ErrorResponse description: Error response model. examples: - error: details: id: ns_123 resource: namespace message: Namespace not found type: NotFoundError status: 404 success: false HTTPValidationError: properties: detail: items: $ref: '#/components/schemas/ValidationError' type: array title: Detail type: object title: HTTPValidationError CompoundIndexPattern: properties: field_combination: items: type: string type: array title: Field Combination description: Fields used together combination_count: type: integer title: Combination Count description: Number of times this combination was used avg_latency_ms: type: number title: Avg Latency Ms description: Average latency for this combination p95_latency_ms: type: number title: P95 Latency Ms description: 95th percentile latency type: object required: - field_combination - combination_count - avg_latency_ms - p95_latency_ms title: CompoundIndexPattern description: Pattern of fields commonly queried together. ErrorDetail: properties: message: type: string title: Message description: Human-readable error message type: type: string title: Type description: Stable error type identifier (machine-readable) code: anyOf: - type: string - type: 'null' title: Code description: >- Fine-grained error code for programmatic handling (e.g., namespace_name_taken, feature_extractor_not_found). Present only when consumers may need to branch on a specific error condition. details: anyOf: - additionalProperties: true type: object - type: 'null' title: Details description: >- Optional structured details to help debugging (validation errors, IDs, etc.) type: object required: - message - type title: ErrorDetail description: Error detail model. ValidationError: properties: loc: items: anyOf: - type: string - type: integer type: array title: Location msg: type: string title: Message type: type: string title: Error Type type: object required: - loc - msg - type title: ValidationError ````