Adding indexes slows down write operations so how do you balance read speed against insert latency

Question

Anonymous · Accepted Answer

1.identify whether we really need many indexes? 2.add clusterd index using
multiple keys depending on which keys are being frequqly used for querying
(userid and created_at) 3. read should direct via read replica, and indexing can
be added to read replica 4. use Query anlyzer to see in which queries we use
sequential scan so that we know which indexes to target to. 5. if indexing
needed for report, then batch run can refresh the indexes in the table 6. add
partial indexing (index on acitve users )

Adding indexes slows down write operations so how do you balance read speed against insert latency

Practice this question with AI

Go Premium

Community Answers

Unlock Full Access

Practice More Questions