Scatter query performance degradation in VTGate
Query Routing and Resource Exhaustion In a Vitess deployment, VTGate is responsible for translating logical SQL queries into shard-specific requests. When a query is executed without a sharding key in the WHERE clause, the system cannot determine a specific destination via the Vindex. This triggers a scatter query, where VTGate broadcasts the request to ever