Maintained with ☕️ by
IcePanel logo

The Spanner index advisor is Generally Available in both GoogleSQL and PostgreSQL-dialect databases

Share

Services

## Feature The Spanner index advisor is Generally Available in both GoogleSQL and PostgreSQL-dialect databases. The index advisor analyzes your queries to recommend new indexes or changes to existing indexes to improve the performance of your queries. For more information, see [Use the Spanner index advisor](https://cloud.google.com/spanner/docs/index-advisor). ## Feature Spanner supports new [SERIAL](https://cloud.google.com/spanner/docs/reference/postgresql/data-types#serial-types) and [AUTO\_INCREMENT](https://cloud.google.com/spanner/docs/reference/standard-sql/data-definition-language#table%5Fstatements) DDL syntax. `SERIAL` is available in PostgreSQL-dialect databases and `AUTO_INCREMENT` is available in GoogleSQL. They streamline the ability to generate `IDENTITY` columns as primary keys. For more information, see [SERIAL and AUTO\_INCREMENT](https://cloud.google.com/spanner/docs/primary-key-default-value#serial-auto-increment).