Re: EXPLAIN: Select tables optimized away

2005-02-17 Thread Gabriel PREDA 
O I see... I read this in MySQL Manual... I believe it's something like
SHOW TABLE STATUS LIKE 'table_name'
And then extract the number of rows... I never saw "Select tables optimized
away" and it confused me !

Gabriel PREDA

- Original Message - 
From: "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 index if I remember correctly.  Mike
>
>
> - Original Message -
> From: "Gabriel PREDA" <[EMAIL PROTECTED]>
> To: 
> Sent: February 17, 2005 6:15 AM
> Subject: EXPLAIN: Select tables optimized away
>
>
> > MySQL 4.1.10
> >
> > What does "Select tables optimized away" mean ?
> >
> > mysql> explain SELECT COUNT(*) AS total FROM members_twining_main;
> > |  1 | SIMPLE  | NULL  | NULL | NULL  | NULL |NULL |
NULL
> |
> > NULL | Select tables optimized away |
> >
> >
> > Gabriel PREDA


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: EXPLAIN: Select tables optimized away

2005-02-17 Thread O'K Web Design 
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, 2005 6:15 AM
Subject: EXPLAIN: Select tables optimized away


> MySQL 4.1.10
>
> What does "Select tables optimized away" mean ?
>
> mysql> explain SELECT COUNT(*) AS total FROM members_twining_main;
> |  1 | SIMPLE  | NULL  | NULL | NULL  | NULL |NULL | NULL
|
> NULL | Select tables optimized away |
>
>
> Gabriel PREDA
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.300 / Virus Database: 265.8.8 - Release Date: 2005-02-14
>
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: EXPLAIN: Select tables optimized away

2005-02-17 Thread Andy Eastham 
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 tables optimized away
> 
> MySQL 4.1.10
> 
> What does "Select tables optimized away" mean ?
> 
> mysql> explain SELECT COUNT(*) AS total FROM members_twining_main;
> |  1 | SIMPLE  | NULL  | NULL | NULL  | NULL |NULL | NULL
> |
> NULL | Select tables optimized away |
> 
> 
> Gabriel PREDA
> 
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]