Date: Sat, 30 Oct 2021 22:37:24 GMT
<p>head to https://database.husseinnasser.com to get a discount coupon for my Introduction to Database Engineering course</p> <p>In this episode of the backend engineering show, I’ll discuss three instances where indexes can be useless and might add overhead to your operations. Let us discuss.</p> <p>0:00 Intro</p> <p>1:34 What is an Index?</p> <p>4:00 The Cost of Indexes</p> <p>6:40 Most values are the similar</p> <p>13:00 WHERE UPPER(NAME)=‘RICK’</p> <p>17:10 Composite Index</p> <p>23:00 How do I know if I’m using an Index</p>