SAP Note 79191 - Creating 'detached indexes'

Component : Informix - Database Administration with Informix

Solution : https://service.sap.com/sap/support/notes/79191 (SAP Service marketplace login required)

Key words :
alter table <table>          drop constraint <primary_key_constraint_name>, subsequent create index greatly contributes, informix database server onconfig file, numberof configured cpu vps, 2k page size = 32 gb, 4k page size = 64 gb, user-defined page size, primary key constraint entry, system displays missing indexes, create unique index <primary_key_constraint_name>

Related Notes :

548943FAQ: Avoiding disk space problems
178012INF-271 without ISAM code
118374
85067Accelerating 'Create index' using PDQ
83183Fragmentation: Basics - decision help
83117
81642Frag./detached index: Special behavior in R3