query-performance-optimizer
Analyze SAP OData queries to identify performance bottlenecks and recommend optimization strategies for improved speed and efficiency.
Instructions
Optimize SAP OData query performance by analyzing execution patterns and suggesting improvements. Automatically identifies bottlenecks and recommends index strategies.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| entityType | Yes | Target entity type | |
| executionStats | No | Query execution statistics | |
| optimizationGoals | No | Primary optimization objectives | |
| query | Yes | Original OData query URL to optimize |
Input Schema (JSON Schema)
{
"properties": {
"entityType": {
"description": "Target entity type",
"type": "string"
},
"executionStats": {
"additionalProperties": false,
"description": "Query execution statistics",
"properties": {
"dataSize": {
"type": "number"
},
"executionTime": {
"type": "number"
},
"recordCount": {
"type": "number"
}
},
"type": "object"
},
"optimizationGoals": {
"description": "Primary optimization objectives",
"items": {
"enum": [
"speed",
"bandwidth",
"accuracy",
"caching"
],
"type": "string"
},
"type": "array"
},
"query": {
"description": "Original OData query URL to optimize",
"type": "string"
}
},
"required": [
"query",
"entityType"
],
"type": "object"
}