4. Working with Secondary Indexes | DynamoDB Applied Design Patterns

Projection

Once we have an understanding of the secondary index, we are all set to learn about projection. While creating the secondary index, it is mandatory to specify the hash and range attributes, based on which the index is created. Apart from these two attributes, if the query wants one or more attribute (assuming that none of these attributes are projected into the index), then DynamoDB will scan the entire table. This will consume a lot of throughput capacity and will have comparatively higher latency.

The following is the table (with some data) that is used to store book information:

Here are few more details about the table:

The BookTitle attribute is the hash key of the table and local secondary index
The Edition attribute is the range key of the table
The PubDate attribute is the range key of the index (let's call this index IDX_PubDate)

Local secondary index

While creating the secondary index, the hash and range key of the table and index will be inserted into the index; optionally...

Tech Concepts

Programming languages

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

DynamoDB Applied Design Patterns

By : Uchit Hamendra Vyas

DynamoDB Applied Design Patterns

By: Uchit Hamendra Vyas

Overview of this book

Projection

Local secondary index

DynamoDB Applied Design Patterns

By : Uchit Hamendra Vyas

DynamoDB Applied Design Patterns

By: Uchit Hamendra Vyas

Overview of this book

Projection

Local secondary index

Confirmation

Buy this book with your credits?

Submit Your Feedback

Create a Free Account To Continue Reading

Sign in to activate your 7-day free access