Prepared Statement
A parameterized statement whose SQL structure is separated from runtime values, improving safety and often enabling statement reuse.
Database Context
A prepared statement separates the SQL structure from runtime values. Bound parameters reduce injection risk and can allow cursor or statement reuse, while plan selection still depends on the database optimizer and the distribution of parameter values.
Performance Boundary
Preparation does not guarantee one permanently optimal execution plan or high performance. Skewed bind values and cardinality estimation can make a plan suitable for one parameter range and poor for another.
Related Database Concepts
- Bind Variable
- Execution Plan
- SQL Injection
- Connection Pool