| Subject | what is better for index : varchar(15) or BIGINT |
|---|---|
| Author | svanderclock |
| Post date | 2010-03-08T21:37:30Z |
hello,
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 ...
thanks by advance
stephane
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 ...
thanks by advance
stephane