Re: Deceiding which index to use

<small><font face="Tahoma">Richard Huxton wrote:<br /> > Mezei Zoltán wrote:<br /> > Q1. Why are you storing a
numericin a varchar?<br /><br /> Because it's not always numeric info. :/<br /><br /> > Q2. How many unique values
doesanumber have? And how many rows in<br /> > subscriber?<br /><br /> About 10k distinct anumbers and 20k rows.
Nothingspecial...<br /><br /> > Q3. What happens if you create the index on plain (anumber) and then<br /> > test
against'555555555'?<br /><br /> Nothing, everything is the same - the problem lies on the other table's index usage,
usingthis index is fine.<br /><br /> Zizi</font><font face="Tahoma"></font><br /></small>