Moritz Lennert wrote:
>Hello,
>
>I have a table with some 2.2 million rows on a Pentium4, 1.8GHz with 512
>MB RAM.
>Some queries I launch take quite a long time, and I'm wondering whether
>this is normal,or whether I can get better performance somehow.
>
>As an example, I have a field which is in char(2), with 23 different
>possible values.
This field is not too selective. Are there any more fields which are always in where condition?
If yes, indexing on more than one field should help.
Tomasz Myrta