- A forced index cannot be used in queries.
- From this query plan, we can see the forced index ncsysusers2 cannot be used in this query:
1> select name from sysusers(index ncsysusers2) where name="dbo"
QUERY PLAN FOR STATEMENT 1 (at line 1).
Optimized using Serial Mode
The type of query is SELECT.
1 operator(s) under root
|ROOT:EMIT Operator (VA = 1)
| |SCAN Operator (VA = 0)
| | FROM TABLE
| | sysusers
| | Index : ncsysusers1
| | Forward Scan.
| | Positioning by key.
| | Index contains all needed columns. Base table will not be read.
| | Keys are:
| | name ASC
| | Using I/O Size 8 Kbytes for index leaf pages.
| | With LRU Buffer Replacement Strategy for index leaf pages.
SAP Adaptive Server Enterprise (ASE) 15.x
"trace flag", hint, optimizer, 15038, -T15038 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
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.