You are asking SQL server to generate a new execution plan every time the query is run this is “pricey” though in the grand scheme of things it is a lot less pricey than using a bad cached plan. There are quite a few entries in the forum about how all this works if you are curious do a bit of searching on
Parameter Sniffing (I think we covered this in one of our podcast episodes)