"O'K Web Design" <[EMAIL PROTECTED]>
Subject: Re: EXPLAIN: Select tables optimized away
> Hi
>
> Counts are extremely fast and since you have no WHERE statement, it
> takes the count value straight from the internals and does not look at the
> tables or an inde
Hi
Counts are extremely fast and since you have no WHERE statement, it
takes the count value straight from the internals and does not look at the
tables or an index if I remember correctly. Mike
- Original Message -
From: "Gabriel PREDA" <[EMAIL PROTECTED]>
To:
Sent: February 17,
Gabriel,
I think it means that this count can be done from an index, so there's no
need to access the actual table at all.
Andy
> -Original Message-
> From: Gabriel PREDA [mailto:[EMAIL PROTECTED]
> Sent: 17 February 2005 11:16
> To: mysql@lists.mysql.com
> Subject: EXPLAIN: Select table
