Use the GCP console to create a secondary index on an existing table. Use this index to improve query performance.
- [Instructor] So the next item we're gonna take a look at…are indexes, and these are secondary indexes.…So again, these are slightly different…than traditional RDBMS.…So in Spanner you can create secondary indexes,…and you would create them on one or more…non-primary-key columns, and you use them just like…you're doing other relational databases to speed up queries,…because they physically copy a subset of the data.…And you create them, either to the console, or Gcloud,…or through the programmatic API.…Couple of points to know about this:…Google recommends that you create secondary indexes…after you perform a bulk upload of data.…
They say that it's possible to do it before,…but it could really slow down bulk uploads,…and these are not small inserts, updates,…they're really just bulk uploads.…You also have the ability to use what they call…a storing column, and what that will do is that'll include…columns from another table in an index,…maybe columns that can't be indexed,…like array columns, for example.…This can be required for join queries to work properly,…
- What is Cloud Spanner?
- Creating an instance and database using the console
- Making hot schema updates
- Cloud Spanner queries
- Loading data into Cloud Spanner
- Understanding transactions
- Cloud Spanner DevOps tools
- Auditing logs with Stackdriver
- Cost optimization
Skill Level Intermediate
Google Cloud Storage and Data Essential Trainingwith Joseph Lowery2h 54m Intermediate
Google Cloud Platform Essential Trainingwith Lynn Langit3h 56m Intermediate
1. Why Cloud Spanner?
2. Cloud Spanner Basics
3. Cloud Spanner Queries
4. Cloud Spanner DevOps
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.