I have a dynamodb table includes 3 fields:
uuid: string
m: string
s: string
timestamp
the UUID is the partition key and timestamp is sort key. I need to build a function to take m
and s
as input and return uuid
to users. In order to improve query performance, I am thinking to create a global secondary index to include m
and s
as partition key.
But I can't find a way to create a composite partition key. Do I have to use m
as partition key and s
as sort key for the global secondary index? What other solutions I can use?