<p><font size="2">> </font><br /><font size="2">> 990 * 2072 = 2,051,280 Bytes</font><br /><font size="2">>
</font><br/><font size="2">> BUT after clustering triples according to an index on att1:</font><br /><font
size="2">></font><br /><font size="2"><snip></font><br /><font size="2">> </font><br /><font size="2">>
142* 8 * 1024 = 1,163,264 Bytes</font><br /><font size="2">> </font><br /><font size="2">> </font><br /><font
size="2">>Is there any compression or what?</font><br /><font size="2">> </font><p><font size="2">varchar means
'charactervarying'. What varies is the length. So a varchar(1000) with 'foo' in it only takes a few bytes ('foo' plus
lengthinfo) instead of 1000 bytes.</font><p><font size="2">If you really want a fixed-length field, nchar or char
shoulddo what you want. </font>
