This is a blog post I wrote after having a couple of work projects lead me to learning far more about indexes than I'd ever bothered to in the past. In particular: Functional, Partial and Covering...
This is a blog post I wrote after having a couple of work projects lead me to learning far more about indexes than I'd ever bothered to in the past.
In particular: Functional, Partial and Covering indexes had never appeared on my radar. I felt like I couldn't be the only one to have slept on the capabilities of indexes beyond the more obvious single and composite index we use all the time.
I'm sure this is less interesting to seasoned database engineers, but perhaps more so to software engineers that have not yet gone very deep with database optimisation.
This is a blog post I wrote after having a couple of work projects lead me to learning far more about indexes than I'd ever bothered to in the past.
In particular: Functional, Partial and Covering indexes had never appeared on my radar. I felt like I couldn't be the only one to have slept on the capabilities of indexes beyond the more obvious single and composite index we use all the time.
I'm sure this is less interesting to seasoned database engineers, but perhaps more so to software engineers that have not yet gone very deep with database optimisation.