Symptom
When capturing create index DDL from ASE running a later version and trying to run the same ddl in a lower ASE version it is failing with the either errors below:
- Msg 9865, Level 16, State 23:
Server 'servername', Line 1:
CREATE INDEX failed. INDEX_HASH_CACHING is not supported for ROW_CACHING disabled table 'tmp_t1'. - Server 'servername', Line 4:
'index_hash_caching' is not a recognized CREATE INDEX option.
Read more...
Environment
- SAP Adaptive Server Enterprise ASE 16.0 SP02 (older version than SP03)
- SAP Adaptive Server Enterprise ASE 16.0 SP03 and later
Product
SAP Adaptive Server Enterprise 16.0
Keywords
index_hash_caching, BTree, Index, BTree Index, btree index, Hash Cached BTree Index, create index , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To
About this page
This 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.