1
00:00:00,270 --> 00:00:06,690
In this video, we are going to create a global secondary index on our Amazon dynamic TV table.

2
00:00:06,720 --> 00:00:10,570
We're using a measurement console for that purpose.

3
00:00:10,590 --> 00:00:16,770
Please go to the console, dynamic DB tables and open order table.

4
00:00:17,100 --> 00:00:24,030
So as you remember that when we design our table, we have these attributes ID partition key, status

5
00:00:24,030 --> 00:00:27,270
sort key and we have the table and order date.

6
00:00:27,330 --> 00:00:33,660
So in this video, I'm going to add the index in this order date attribute, which will which will be

7
00:00:33,660 --> 00:00:35,430
the global secondary index.

8
00:00:35,490 --> 00:00:44,820
So let me copy this order date and go to the index page and click the create index page.

9
00:00:45,910 --> 00:00:49,120
And purchasing key will be the order date.

10
00:00:49,120 --> 00:00:54,090
When you set the order date, the index name come in here or the date the index.

11
00:00:54,100 --> 00:00:59,200
We don't have any sort key and if you scroll down you can see the other complication.

12
00:00:59,200 --> 00:01:03,430
I am going to leave as it is and click the create index button.

13
00:01:06,940 --> 00:01:10,650
So this will take some time to creating this index.

14
00:01:10,660 --> 00:01:13,860
You can follow the status with refreshing this page.

15
00:01:13,870 --> 00:01:20,080
So as you can see that we have successfully create a global secondary index on Amazon Dynamic DB table.

16
00:01:20,110 --> 00:01:26,380
We're using a measurement console now we can query over this global secondary index on all the table.