Results for “query-tuning”

Diagnose and optimize existing slow SQL queries using execution plans, indexing strategies, query rewriting, and ORM tuning. Use when the user provides a query, performance symptom, or EXPLAIN plan; use sql-query-generation when creating a new query from requirements.

Optimize SQL queries, indexes, and database performance across MySQL, PostgreSQL, SQL Server, and Oracle with execution plan analysis and universal tuning techniques.

Optimize PostgreSQL databases with advanced features, performance tuning, and best practices for JSONB, full-text search, window functions, and indexing.

Optimizes database queries and improves performance across PostgreSQL and MySQL systems by analyzing execution plans, designing index strategies, and tuning configurations.

Guides scaling Qdrant query throughput (QPS) through performance tuning, horizontal scaling with read replicas, and disk I/O optimization.

Master modern SQL with cloud-native databases, OLTP/OLAP optimization, and advanced query techniques. Expert in performance tuning, data modeling, and hybrid analytical systems.

Guides database index selection, creation, and maintenance with SQL examples for PostgreSQL and MySQL.

Master modern SQL with cloud-native databases, OLTP/OLAP optimization, and advanced query techniques. Expert in performance tuning, data modeling, and hybrid analytical systems.

Use when optimizing SQL queries, designing database schemas, or tuning database performance. Invoke for complex queries, window functions, CTEs, indexing strategies, query plan analysis.

Master modern SQL with cloud-native databases, OLTP/OLAP optimization, and advanced query techniques. Expert in performance tuning, data modeling, and hybrid analytical systems.

Diagnoses and improves Qdrant search relevance by isolating embedding model, configuration, or query strategy issues.

Master modern SQL with cloud-native databases, OLTP/OLAP optimization, and advanced query techniques. Expert in performance tuning, data modeling, and hybrid analytical systems.

Diagnoses and resolves slow Qdrant search performance issues including high latency, low throughput, and slow filtered searches.

Master modern SQL with cloud-native databases, OLTP/OLAP optimization, and advanced query techniques. Expert in performance tuning, data modeling, and hybrid analytical systems.

Optimizes SQL queries with execution plan analysis, index suggestions, and query rewriting

Self-tuning question sensitivity + developer psychographic for gstack (v1: observational). (gstack)

Optimize machine learning model hyperparameters using grid search, random search, Bayesian optimization, and Hyperband to maximize model performance within a compute budget. Use when the user requests hyperparameter tuning or provides relevant inputs for this workflow.

Master modern SQL with cloud-native databases, OLTP/OLAP optimization, and advanced query techniques. Expert in performance tuning, data modeling, and hybrid analytical systems.

Use when debugging slow SQL queries, designing database indexes, or rewriting queries for better performance. For EXPLAIN analysis, index strategy, N+1 problem resolution, and query optimization patterns.

Adds autotuning to CuTile kernels using the exhaustive_search API with a tune-once/cache/direct-launch pattern, covering occupancy-only and complex tile-size search spaces.

Guides selection of Qdrant search strategies including hybrid search, reranking, relevance feedback, MMR, and discovery APIs to improve retrieval quality.

Diagnoses Qdrant search quality issues by isolating causes like HNSW approximation, quantization, embedding model, or search pipeline problems.

Diagnoses and resolves slow Qdrant indexing and data ingestion by optimizing batching, sharding, HNSW parameters, and payload indexing strategies.

Optimizes Qdrant query performance for large limits across multiple shards by using Poisson-distributed subsampling to reduce inter-shard data transfer.

Guides scaling decisions for Qdrant vector databases based on data volume, query throughput, latency, or query volume.

Diagnose and optimize slow-loading, high-memory, or low-FPS USD scenes using a structured workflow with profiling, validation, and mutation phases.

Fine-tune open models or Gemini models using Agent Platform infrastructure, from environment setup through data preparation, job configuration, monitoring, and deployment.

Provides best practices for optimizing MariaDB queries, including indexing strategies, EXPLAIN analysis, pagination, histogram statistics, and MariaDB-specific optimizer settings.

Optimizes SQL queries, designs database schemas, and troubleshoots performance issues using execution plan analysis, indexing strategies, and set-based operations.

`task-agent`/`review-agent`: use when broker delivery, ordering, acknowledgement, DLQ, backpressure, or replay changes; skip synchronous retry without message semantics.