There are two types of stored procedures: user-defined and precompiler-generated. Both types run faster than standalone statements because Adaptive Server preoptimizes the queries. You create user-defined stored procedures, and the precompiler generates stored procedures.
