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 from>your replies, and possibly have better Ideas than me.That was my intention. I made a mistake.>Oscar Picasso wrote:>>> I cannot gr

[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