Re: efficient query for: "it's your birthday today"

[Jigal van Hemert]

From: "Rhino" <rhino1@stripped>
> I don't know if it is more efficient but I would write this query as
> follows, simply because it is easier to understand what it is doing when
you
> look at it:
>
> select [whatever columns you want]
> from mytable
> where month(birthdate) = 11
> and dayofmonth(birthdate) = 7;

Sorry, same speed (approx 0.18 sec). This seems to be the speed at which a
full tablescan can be performed on this recordset.

I guess we have to make some adjustments before the table can grow to
500,000+ records...

Regards, Jigal.