Re: estimating size of Primary Keys using hash
Hi,
richard horan wrote:
> Sorry. i found another section that describes
> this.
>
> The size of the hash index is 25 bytes per record,
> plus the size of the primary key. For primary keys
> larger than 32 bytes another 8 bytes is added.
This is correct for version 4.1. For version 5.0 and 5.1 it is
a fixed size of around 25 bytes per record.
Rgrds Mikael
Mikael Ronstrom
Senior Software Architect, MySQL AB
My blog:
http://mikaelronstrom.blogspot.com
Subject
Views
Written By
Posted
1815
May 23, 2006 04:45AM
1086
May 23, 2006 04:54AM
Re: estimating size of Primary Keys using hash
1090
May 31, 2006 12:05AM
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.