>
> Are you really using concatenated strings containing several distinct
> dataitems as your key? Given your example the identifier for Manhattan
> is 27 bytes, if you would use a key of seperate fields you need a
> CHAR(2), and 3 INTEGERs so 2 bytes + 3*4 bytes = 14 bytes. Assuming that
> the identifier for NEW YORK(State) is globally unique, you probably
> don't even need to use the US prefix losing 2 bytes.
>

yes it's can be better ... it's was just done like this at the beginning

> Individual fields:
> WHERE country_code = 'US' and nb_bedroom > 2 and nb_bedroom < 3
>
> (BTW: I assume you are aware that that condition is always false, unless
> New York as fractional rooms ;)
>

stupid exemple sorry :(


[Non-text portions of this message have been removed]