DynamoDB Scan vs Query - The Things You Need To Know

[@ralfrolfen5504]

Really good content! Well presented! No annoying background music. No annoying intro to the channel. No "Hey what's up guys". No strange accent; Just good, plain English.

[@BeABetterDev]

Glad you enjoyed it!

[@srb1855]

Excellent video! The release of your video is fortuitous - I am studying for my first AWS certification and just completed a dynamoDB lab the other night. However none of these subtleties you described were highlighted. Thanks for providing your insights. 👍

[@__hazelnut]

Good video, but I don’t quite understand how query lookup is O(1). How is that possible if we are searching the table for the matches to our query? Isn’t it based on the size of our table, so O(n) or larger?

[@fafapw]

Great video, dude! In my case, I'm using PK , but I have others 3 GSIs. The behavior is the same using GSI and his sort key comparing with PK + his sort key? thanks in advance!

[@BeABetterDev]

Hi Fabricio! The Sort key logic applies the same way to GSIs as it does to PKs. Hope this clarifies!

[@mumtazirteqaahmed8553]

Great explanation! On Point!

[@jesusesquivelroman7524]

Very nice video! Very educational. What if in my Customer Order table I have other fields like "Country" and "Product Type" and I want to filter, for example, "Tech" products bought in the "US". How will I query or fetch that data?

[@BullishBuddy]

Wonderful video!!

[@pablogonzalezrobles4429]

Nice video. Question: How should be format the datetime for using query with between? dd:mm:yyyy hh:mm:ss? Or do we need to separate date and time? Any suggestions about querying dt columns.

[@adds-kz3oc]

Personally, I convert DateTimes to Unix timestamps. 28:10:2021 20:00:00 => 1635447600. You can then query for values less than, greater than, or between the dates.

[@hoddybhaba6704]

impeccable!!!

[@BeABetterDev]

Thanks Hoddy!

[@tiagosantos680]

Super well done video

[@DuyLe-gq6cu]

I use query to get data, but it also limit 1mb data like you explain scan.

[@jonathanduran2921]

Can you do operations like give me all customers with id greater than 1 on the partition key? Or are you limited to one value for the partition key for each query?

[@karimfayed3050]

Great Video! But what if I want to return a list with all my primary keys which method should I use and how to use it?

[@albintsafack1232]

Hi ! please did you find the answer of this question ? I'm also asking me this question

[@moneeshkumar1838]

Is it possible to parallel query operation? Just like parallel scan operation

[@BeABetterDev]

Hi Moneesh, I don't know of any built-in method to do this beyond using multiple threads and firing off separate queries. There's a good article on this topic by AWS here: aws.amazon.com/blogs/database/use-parallelism-to-optimize-querying-large-amounts-of-data-in-amazon-dynamodb/ Hope this helps

[@moneeshkumar1838]

@@BeABetterDev Thanks Man Appreciated

[@kerisnarendra]

Is it additional cost when querying on GSI?

[@hetalraval3928]

In my case i want to scan all data each time to compare with my response to know where update occur or insert and according to that i want to perform other requests...so what could be the best possible way?

[@fadichamieh]

put a modified/created timestamp in your data, and filter based on that

[@vimalpatel44]

are RangeKey and sortkey same?

[@dadestor]

Yes

[@rickharold7884]

Cool.

[@naga_sai]

Do we need to Partition key all the times while querying (When I want to filter based on other normal keys)?

[@zagamendes2438]

You said when using query I need to know my pk, but what if I just want to list my data? Eg to do list, Will I have to use scan?