At 12:14 PM -0400 10/29/99, PinkeshP@stripped wrote:
>following query takes 28.52 seconds!!!
>
>mysql> select count(*) from reminder where custid="abcd10asdf5";
>+----------+
>| count(*) |
>+----------+
>| 5553 |
>+----------+
>1 row in set (28.52 sec)
>
>I have total of 109229 records in table. custid column is indexed.
>Anyone help me to make this query run faster?
Indexed how? As the first column of an index, or as the 2nd (3rd,
etc.) column of
a multiple-column index?
--
Paul DuBois, paul@stripped
