Skip to Content
0
Mar 09, 2010 at 02:43 PM

'key contains unsortable types' when importing client?

59 Views

Hello gurus,

while doing a client copy, during the import for some tables we get the message:

'full scan in 4134406 entries because binary search is not possible for this table because key contains unsortable types, this may result in loss of performance'

In deed, the performance while writing those tables is REALLY bad.

Does anyone know what exactly might be wrong with those tables (all of them are Z-tables)?

We checked the export-logs, too and for those tables there are entries like

'3WETW000 scrap char 0x00 found in ZTABLE04.TXZ01, it will be coerced to ' ' automatically'

Could this have anything to do with the low performance at import?

Thanks

Alicia