[PERFORM] Better index stategy for many fields with few values

Hi,I want to optimize something like this.- My items table:code int -- can take one of 100 valuesproperty varchar(250) -- can take one of 5000 valuesparam01 char(10) -- can take one of 10 valuesparam02 char(10) -- can take one of 10 values...[ 20 similar columns }...parama20 char(10) -- can take

Re: [PERFORM] Better index stategy for many fields with few values

Hi Markus,Markus Schaber [EMAIL PROTECTED] wrote:Hi, Oscar,Please reply to the list and not privately, so others can learn fromyour replies, and possibly have better Ideas than me.That was my intention. I made a mistake.Oscar Picasso wrote: I cannot group the columns logically. Any column may or