The SAP ASE server automatically recompiles stored procedures after executing create index statements. Although ad hoc queries that you start before executing create index continue to work, they do not take advantage of the new index.In SAP ASE versions 12.5 and earlier, create index was ignored by cached stored procedures.