> > 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]
