Is there a benefit to parameterizing SQL WHERE clauses that always have the same value?

29 Views Asked by At

This question came up recently and I couldn't find any information on it. lets say I have an SQL query like the following:

SELECT * FROM example_table WHERE type=1

The type that I'm selecting will never change. Are there any benefits, for performance or otherwise, to parameterizing this SQL (specifically adding the "1" as a parameter)?

My initial thought is that there wouldn't be, but someone I was talking to about this indicated that there probably would be, but didn't explain any further

0

There are 0 best solutions below