Parameter sniffing is good and bad. You want it, but without bad consequence.

It’s great for what it does. But when it goes badly, can cause some serious puzzle chases.