Re: [GENERAL] Expensive query

At 02:13 PM 10/30/98 , you wrote:
>    That users table looks kinda useless.  I'd recommend changing id
>to name and making id an int, then putting your events users in as ints.
>Currently, it doesn't do anything at all, and you might as well be doing
>this query [...]

Actually, the real-life 'users' table has lots of fields, none of them
relevant to the question at hand.

>    I would also recommend not making code a char(10).  If you put an
>index on code and an index on date, you should be able to get your results
>pretty quick.

They are indexed.

Using ints is not unreasonable, but does not explain the pathological behavior.