| Subject | RE: [firebird-support] Index on character type column: CHAR or VARCHAR ? |
|---|---|
| Author | Alan McDonald |
| Post date | 2004-09-17T10:48:06Z |
>Someone will correct me if I'm wrong but indexes are limited to 128 bytes,
> And with regard to
>
> - a search index for a character column ?
> - the character column being referenced as a JOIN condition ?
>
>
it makes no difference if you are using a CHAR or a VARCHAR to create the
index and performance in the search will be the same.
Alan