2418524 - Table scan may be chosen if a local variable is used as a search argument in a select into statement in a stored procedure - SAP ASE

• Table scan may be chosen if a local variable is used as a search argument in a select into statement in a stored procedure like below:
  create procedure test1_proc2
  as
  declare @col1 int
  select @col1 = 10
  select * into #temp from test1 where col1 = @col1
  go

• As a result, the query performance can slow down.

• SAP Adaptive Server Enterprise (ASE) 15.x
• SAP Adaptive Server Enterprise (ASE) 16.0

procedure deferred compilation, slow, drop, performance, local variable, tablescan, indexscan, select-into , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To