Back to feed
GCP·Spannerfeature·

Spanner supports the FACTORIZED_MODE join hint.

Spanner supports the FACTORIZED_MODE join hint. You can control which sides of a join to factorize (deduplicate) before executing the join by using the FACTORIZE_LEFT, FACTORIZE_RIGHT, or FACTORIZE_BOTH hint values. For more information, see Factorized mode.

Read original announcement

More from Spanner

Spanner Graph supports a suite of graph algorithms covering use cases such as fraud detection, entity resolution, and recommendations.May 27, 2026You can optimize Spanner Graph query performance by using factorized execution.May 18, 2026Spanner Studio supports query parameters, which let you bind literal values to a templated SQL statement at query time...May 15, 2026The Spanner change streams default retention period has been increased from 1 day to 7 days.May 14, 2026