I interviewed one of the creators of the Git sparse index a while back: https://www.softwareatscale.dev/p/software-at-scale-32-derri... which had some interesting tidbits.