- 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
declare @col1 int
select @col1 = 10
select * into #temp from test1 where col1 = @col1
- 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
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.