DynamoDB sort key design: why a filtered Query still scans
A Query is not automatically cheap. In a test partition of 6,000 pet documents, a Query that filtered on pet_id read all 6,000 items and used 319 read capacity units to return 3. The same request against a composite sort key, OWNER#<owner>#PET#<