09-17-03, 07:01 #1Registered User
- Join Date
- Sep 2003
Unanswered: tbcheck returns > 8 extents for tables
Informix online - INFORMIX-SQL Version 5.10.UC2.
The result of 'tbcheck -ce' lists some non-system tables having more that 8 extents.
I think tables having > 8 extents will result poor performance.
Could anyone please tell the possible ways of reorganising (defragmenting) the affected tables.