2831945 - Why aren't index hints supported for the target of a DELETE? - SAP ASE

The syntax specification for the DELETE command does not support forcing an index against the target of the delete, it is only supported for lookup tables.

delete
[top <unsigned_integer>]
[from] [[<database>.]<owner>.]{<table_name> | <view_name>}     <-------- No forceindex  clause here
[where <search_conditions>]
[plan "<abstract plan>"]

delete [[<database>.]<owner>.]{<table_name> | <view_name>}    <---------- No forceindex clause here
[from [[<database>.]<owner>.]{<table_name> | <view_name> [readpast]
[(index {<index_name> | <table_name>}                                       <---------- Forceindex clause is supported here
[prefetch <size>][lru|mru])]}
[readpast]
[, [[<database>.]<owner>.]{<table_name> | <view_name> [readpast]|
[(index {<index_name> | <table_name>}                                      <---------- Forceindex clause is supported here
[prefetch <size>][lru|mru])]
[readpast]} ...]
[where <search_conditions>]]
[plan "<abstract plan>"]

Read more...

• SAP Adaptive Server Enterprise (ASE)
• SAP Adaptive Server Enterprise Cluster Edition (ASE CE)

SAP Adaptive Server Enterprise 12.5 ; SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 15.7 Cluster Edition ; SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise 16.0 Cluster Edition ; Sybase Adaptive Server Enterprise 12.5 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5 ; Sybase Adaptive Server Enterprise Cluster Edition 15.0 ; Sybase Adaptive Server Enterprise Cluster Edition 15.5 ; Sybase Adaptive Server Enterprise Cluster Edition 15.7

Sybase, ASEServer, SAPASE, dataserver, index hint, showplan, delete, forceindex , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , How To