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