Send feedback Query syntax in GoogleSQL Stay organized with collections Save and categorize content based on your preferences. Query statements scan one or more tables or expressions and return the computed result rows. This topic describes the syntax for SQL queries in GoogleSQL for Spanner. SQL syntax notation rules The following table lists and describes the syntax notation rules that GoogleSQL

Send feedback Secondary indexes Stay organized with collections Save and categorize content based on your preferences. In a Spanner database, Spanner automatically creates an index for each table's primary key. For example, you don't need to do anything to index the primary key of Singers, because it's automatically indexed for you. You can also create secondary indexes for other columns. Adding a

Send feedback Optimizing Schema Design for Spanner Stay organized with collections Save and categorize content based on your preferences. Google storage technologies power some of the world's largest applications. However, scale is not always an automatic result of using these systems. Designers must think carefully about how to model their data to ensure that their application can scale and perfo

Send feedback Schema design best practices Stay organized with collections Save and categorize content based on your preferences. The distributed architecture of Spanner lets you design your schema to avoid hotspots - situations where too many requests are sent to the same server which saturates the resources of the server and potentially causes high latencies. This page describes best practices f