2854142 - Table scan is chosen if LIKE clause concatenates parameters or variables - SAP ASE

• ASE optimizer may choose a table scan or an unsuitable index scan if a LIKE predicate in WHERE clause contains :
• a concatenation of parameters (e.g. LIKE ? + ? or LIKE ? || ?) in a prepared statement
• or a concatenation of local variables (e.g. LIKE @var1 + @var2 or LIKE @var1 || @var2) in a batch query.

• SAP Adaptive Server Enterprise 15.7
• SAP Adaptive Server Enterprise 16.0

757177, CR#757177, CR757177, LIKE optimization , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem