Database Reference
In-Depth Information
Optimizing frequent queries to avoid fetches
Frequently used queries should return the output faster. To do this, all the attributes used in
the frequent queries must be projected into the secondary index and, depending on the fre-
quency of query usage, the provisioned throughput also has to be set. Even if one of the at-
tributes is not projected into the index then the query will scan the entire table, which will
increase the latency. However, we need to keep one thing in mind, that occasional querying
might become frequent querying sometimes, but during that time we cannot add (project)
this attribute into the index .
Search WWH ::




Custom Search