I have a question for the experts, when putting an index on an ASA 8.0.2 database do you put the most unique field first or least unique.
For example say you have 3 columns....... location(least unique),style,UPC(most unique).
Would your index be location,style,upc
or
upc,style,location ?

Thanks,
Byte

Yes, it's more powerfull when your're using a SARG in the 3 fields. But a problem exists : if you only know the localisation and the style, the index won't be used...

Most unique first, absolutely. I've been burned in the distant past by trying it the other way.