To take advantage of prepared statements (adhoc(false)), is it necessary or advised to use them with the parameterized queries?
So, is this suitable?
Also, I’m aware that there is a limit of 5000 prepared statements. So, when using non-parameterized queries as above, do two identical queries with different values for the where clause use different prepared statements?
EG Would the following 2 queries used as above use the same prepared statement?
select * from default where name = 'fred';
select * from default where name = 'dave';