OLE DB includes several functions for executing SQL statements:
Direct execution ASE parses the SQL statement, prepares an access plan, and executes the statement. Parsing and access plan preparation are called preparing the statement.
Bound parameter execution You can construct and execute a SQL statement using bound parameters to set values for statement parameters at runtime. Bound parameters are also used with prepared statements to provide performance benefits for statements that are executed more than once.
Prepared execution The statement preparation is carried out separately from the execution. For statements that are you want to execute repeatedly, this avoids repeated preparation and, as a result, improves performance.
