Symptom
When each elements in p-key are varchar columns, depending inserted data byte length, the total used space of p-key reports different.
In real customer production system, a table with pkey of varchar(250) columns spent 84 GB, whereas varchar(128) column took 53 GB.
Below is test tables and allocation status.
pkey of t_vchar128 : Total 2512 KBytes allocated ( sp_iqindexsize )
- inserted 10,000 rows and each column has 128 bytes data length
pkey of t_vchar250 : Total 2496 KBytes allocated
- inserted 10,000 rows and each column has only 128 bytes data length
pkey of t2_vchar128 : Total 1584 KBytes allocated
- inserted 10,000 rows and each column has only 10 bytes data length
pkey of t2_vchar250 : Total 2496 KBytes allocated
- inserted 10,000 rows and each column has only 10 bytes data length
(* t_vchar128, t_vchar250 & t2_vchar250 are similar usage. But t2_vchar128 is much different )
Questions are ,
- There are different sizes between t2_vchar128 and other tables, What's reason for this ?
- It seems Pkey treats CHAR or VARCHAR types to same type. Does it ? any comment will be helpful to me.
Read more...
Environment
SAP IQ16.1 SP02.15
Product
Keywords
819776, pkey size, p-key, 'primary key',Varchar, , KBA , BC-SYB-IQ , Sybase IQ , How To
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.