MySQL Forums
Forum List  »  NDB clusters

Re: questions on the size example in documentation
Posted by: Mikael Ronström
Date: May 31, 2006 12:02AM

Hi,
> ----------
> Question: the two ordered indexes on columns a and
> b, if they where say VARCHAR(32) would it still be
> only 10 bytes per record for the ordered index?
> what if they were VARCHAR(128)?

The ordered indexes remain around 10 bytes in size independent of size
of indexed field(s). The reason is that the index contains only a reference
to the real record (it's a main memory index).

So the answer is yes, it would still be 10 bytes if it was a VARCHAR(128).

Rgrds Mikael

Mikael Ronstrom
Senior Software Architect, MySQL AB
My blog: http://mikaelronstrom.blogspot.com

Options: Reply• Quote


Subject
Views
Written By
Posted
Re: questions on the size example in documentation
1429
May 31, 2006 12:02AM
1310
May 31, 2006 01:20AM
1229
June 05, 2006 09:28AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.