Ravi Sir's Cards › AWS
Sparse GSI
This revision card explains Sparse GSI. It starts from the need that indexing every player wastes writes and complicates unrank. It describes only scored players set lb_pk/lb_sk; omit to unrank. The how-to section covers how to create GSI , then set attrs on scorers , then Query top-N , then remove attrs to unrank. An example on the card is jisoo Park keeps unscored players off the index.
Read card text
What this card says
Why do we need it?
Indexing every player wastes writes and complicates unrank.
What is it?
Only scored players set lb_pk/lb_sk; omit to unrank.
sparse GSI
How to do it
Create GSI → set attrs on scorers → Query top-N → remove attrs to unrank.
Example
Jisoo Park keeps unscored players off the index.