SAP Knowledge Base Article - Preview

2732381 - Wrong index being selected when statement cache is turned on - ASE

Symptom

A simple update statement generates a different plan with statement cache on verses statement cache off:

UPDATE mydb..mytable 
        SET  duration  = c.duration
        FROM #chunk c,
             mydb..mytable p
        WHERE p.asof_date = c.price_date
        AND   p.cusip     = c.cusip

Why is this happening?


Read more...

Environment

  •  SAP Adaptive Server Enterprise (ASE) 15.7
  •  SAP Adaptive Server Enterprise (ASE) 16

Product

SAP Adaptive Server Enterprise 15.7

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

About this page

This 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.