nrac...@gmail.com]
>Sent: Friday, October 09, 2009 1:39 AM
>To: Daevid Vincent
>Cc: mysql@lists.mysql.com
>Subject: Re: Trying to index a table - cant figure out best way
>
>Hi Daevid,
>
>Thanks - have tried this - but an explain still shows that its going through
>all
Hi Daevid,
Thanks - have tried this - but an explain still shows that its going through
all the articles. See below - note these arent all records, ive taken a
snapshot of the views for a 2 week period to test with:
This is without the index:
1 SIMPLE article_views ALL *NULL* *NULL* *NULL* *NULL*
ALTER TABLE articles ADD INDEX date_idx (date);
> -Original Message-
> From: Ian [mailto:barnrac...@gmail.com]
> Sent: Thursday, October 08, 2009 12:23 PM
> To: mysql@lists.mysql.com
> Subject: Trying to index a table - cant figure out best way
>
> Hi,
>
> I have a table that stores ar
