| Subject | Re: [firebird-support] what is better for index : varchar(15) or BIGINT |
|---|---|
| Author | Ann W. Harrison |
| Post date | 2010-03-08T22:11:14Z |
svanderclock wrote:
they compare as octets - just bytes. Data type and collation don't
matter, except as they make keys bigger - and some collations have a
major effect on key size.
Good luck,
Ann
> hello,The only real difference is compression. All index keys are built so
>
> for a multi colum index, what is the best choice for one of the column: varchar(15) or BIGINT ? or doesn't really matter ?
>
> it's a lot of work to move our field from varchar(15) to BigInt, so i rather want to be sure before to do it that they will be some advantage ...
they compare as octets - just bytes. Data type and collation don't
matter, except as they make keys bigger - and some collations have a
major effect on key size.
Good luck,
Ann