SAP Knowledge Base Article - Preview

2661359 - 'index_created' shows 'NULL' in sp_helpindex output - SAP ASE

Symptom

1> sp_helpindex table_name
2> go
Object has the following indexes

index_name index_keys     index_description index_max_rows_per_page index_fillfactor index_reservepagegap index_created       index_local
---------- ------------------------------------------------------------------ ----------------- ----------------------- ---------------- -------------------- ------------------- ------------
index_name1  col1, col2                  clustered, unique                 0                               0                    0                           NULL                      Global Index

index_name2  col2, col4                  nonclustered                       0                               0                    0                          May 05 2018  16:04PM    Global Index

(2 rows affected)

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 12.5
  • SAP Adaptive Server Enterprise (ASE) 15.0
  • SAP Adaptive Server Enterprise (ASE) 15.5
  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

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

Keywords

sp_helpindex, index_created, NULL, crdate, sysindexes , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.