Back to feed
GCP·Spannerfeature·
AI Insights

Spanner supports automatic parameterization of SQL query literals to improve query performance, reduce latency, and lower CPU costs.


Spanner supports automatic parameterization of SQL query literals to improve query performance, reduce latency, and lower CPU costs. Spanner converts literal values hardcoded in CRUD-style queries, such as primary key lookups, index lookups, and primary key joins, into query parameters, allowing execution plans to be cached and reused to reduce latency and CPU costs.

For more information, see Use query parameters and statement hints (GoogleSQL and PostgreSQL).