Add a secondary table index. Execute a SQL query with an index hint which forces Spanner to use your new secondary index.
- [Instructor] So now that we have data in our database,…let's look at queries and query optimization.…So inside of our test instance, in our example DB.…If we click on the albums table,…we'll see that we don't have any secondary indexes.…Do you remember what these are from previous movie?…They're basically additional indexes…that are used in service of making queries faster,…because they're making as with tradition RDBMS…secondary indexes, copies of subsets of information.…Now you can create an index from the console,…but we can also do it with G Cloud.…
Now it's interesting to look…at Google's design patterns, and in their samples,…they tend to not use a console at all.…They tend to use G Cloud for schema or structure.…Initial setup of tables, and subsequent additions…of things like secondary indexes.…You might remember from a previous movie…that Google recommends that if you're doing bulk loading…on a regular basis into your tables and your database,…that you add the secondary indexes after that point.…So you'll see G Cloud being used…
- 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.