[mickael-kerjean]

I recently finished a contract at a company who has gone full on dynamo with the idea that if we have slow queries and dynamo is good for Amazon, then it's good for us too. I've ran some explain on the queries causing issues and of course those queries didn't leverage indexes like they thought ....

[redditor98654]

How did you run explain queries on DynamoDB? Or may be you mean something different and I misunderstood you?

[mickael-kerjean]

I ran explain on the original mysql implementation. The basis of the migration project to dynamo was mysql couldn't cope with our scale but that was bullshit

[bdavisx]

That doesn't make sense, you have to specify the index when you're using Dynamo.

[scarface_74]

You can do scan operations and if they use PartiQL it hides whether you are using indexes.

I usually have an explicit DENY for dynamodb:Scan for the IAM role used to access the DDB table