- ASE opimizer does not choose an index on a temporary table if the temp table and the index are both created in the same batch, and table scan is chosen instead.
- Even if you specify the index in a select statement by using the (index index_name) clause, you get a message below and the index is not chosen.
Index 'index name' specified as optimizer hint in the FROM clause of table '#table name' does not exist. Optimizer will choose another index instead.
- SAP Adaptive Server Enterprise 15.x
- SAP Adaptive Server Enterprise 16.0
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 for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.