In this video, we are going to create a global secondary index on Amazon Dynamic TV table with using
a measurement console.
So it takes almost 5 minutes to create a global secondary index.
In this step, we will query a global secondary index on the our order table using the DB console.
So we are going to go to the order tables orders and verify that your index is active and click the
explore table items and scroll scan command and run this command.
You can see that we have two item, but the first item has no value on order that let's modify the first
item and add these attributes.
We can see in here.
Order date and give the value.
Is this kind of value and save this value?
Yes.
So as you can see that we have basically add order date of any item of our order table.
Now we can query over these items with using the Global Secondary Index.
To do that, please click the query button.
And this time I'm going to select our index file, which is the when I first try, I can't see the index
in this dropdown list.
So after that I have control f five this page.
So that means how to load the page.
And you can also click the F 12 and come here right click and make harder load.
So after the harder load you can see that in the query section we can see the our index list in here.
So this time I'm going to select order date index, which is the our global secondary index and we are
going to perform all.
Holiday do.
Okay, so I'm providing this information and run this query.
So as you can see that we can run query over the global secondary index and get back response from the
Dynamo DB and see the item is come from the order date.
So as you can see that now we can query our global secondary index on the order table with using the
measurement console.