---
title: "Michael Nielson (@safetytrick) | Hashnode"
description: "Michael Nielson (@safetytrick) writes on Hashnode. Read their latest articles and follow their work."
url: "https://hashnode.com/@safetytrick"
---

@safetytrick

# Michael Nielson

@safetytrick · Joined August 2021

## Comments

[This is misleading: But, It will still do a full table scan because we are using "amount" column to calculate the total. So, we need to put an index on "amount" column too. Two indexes don't add together (you might look up covering index). There are also very legitimate reasons why the database will ignore an index that could be applied and do a full table scan anyway. You've explained a few behaviors of indexes but not really how they work.](https://hashnode.com/posts/how-database-indexing-actually-works-internally/60641370f7e8f90bd1d5eb96/comment/6120dc71e404793819ca9144)

Comment · Article · Aug 21, 2021 · [How database indexing actually works internally?](https://hashnode.com/posts/how-database-indexing-actually-works-internally/60641370f7e8f90bd1d5eb96)
