| 1. |
How To Create Local Secondary Indexes? |
|
Answer» A Local secondary index needs to be created at the time of creating a table that can’t be added currently. So, later when you create a local secondary index, try specifying the following two parameters. Indexed Sort Key : The attribute on which INDEXING and querying are performed. Projected Attributes : It is the LIST of attributes from the table that can directly be COPIED into the local secondary index. WITHOUT projected attributes, the local secondary index contains only primary KEYS and secondary keys. A Local secondary index needs to be created at the time of creating a table that can’t be added currently. So, later when you create a local secondary index, try specifying the following two parameters. Indexed Sort Key : The attribute on which indexing and querying are performed. Projected Attributes : It is the list of attributes from the table that can directly be copied into the local secondary index. Without projected attributes, the local secondary index contains only primary keys and secondary keys. |
|