Dynamic SQL is built and prepared at runtime

necessary when the SQL text varies (different tables, different WHERE columns). Use PREPARE once and EXECUTE many times when possible. Always use parameter markers to maximize dynamic statement cache hits.