SAP Knowledge Base Article - Preview

2912214 - Suboptimal query plan resulting in out of space issue in tempdb - SAP ASE


  • Large tempdb already configured
  • Can't allocate space for object 'temp worktable' in database 'tempdb' because 'system' segment is full/has no free extents.
  • Query contains several join conditions
  • Server is configured with allrows_dss. Testing with allrows_oltp or allrows_mix did not help
  • Increasing the 'optimization timeout limit' to as large as 40% did not help
  • With 'forceplan on', query executes fast and tempdb does not run out of space 



SAP Adaptive Server Enterprise 16.0 SP03 PL0x


SAP Adaptive Server Enterprise 16.0


1105, temp worktable, forceplan , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

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.