In this video, we are going to create a global secondary index on our Amazon dynamic TV table.
We're using a measurement console for that purpose.
Please go to the console, dynamic DB tables and open order table.
So as you remember that when we design our table, we have these attributes ID partition key, status
sort key and we have the table and order date.
So in this video, I'm going to add the index in this order date attribute, which will which will be
the global secondary index.
So let me copy this order date and go to the index page and click the create index page.
And purchasing key will be the order date.
When you set the order date, the index name come in here or the date the index.
We don't have any sort key and if you scroll down you can see the other complication.
I am going to leave as it is and click the create index button.
So this will take some time to creating this index.
You can follow the status with refreshing this page.
So as you can see that we have successfully create a global secondary index on Amazon Dynamic DB table.
We're using a measurement console now we can query over this global secondary index on all the table.