From: Eric Bergen
Date: September 22 2004 10:19pm
Subject: Re: help!!!!!!!!!!
List-Archive: http://lists.mysql.com/mysql/172993
Message-Id: <11b1bd9904092215196cad43c0@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

Sven,
  This warning is telling you there your query is going to execute
very slowly. The EXPLAIN that it talks about is mentioned in the
manual here:
http://dev.mysql.com/doc/mysql/en/EXPLAIN.html

You should also search the manual for sections on query optimization
and index usage.

Here is another document that will help you get help online easier. 
http://www.catb.org/~esr/faqs/smart-questions.html

-- 
Eric Bergen
eric.bergen@stripped


On Sun, 19 Sep 2004 07:50:14 +0200, Sven <local.host@stripped> wrote:
> 
> 
> Warning: mysql_query() [http://www.mysql.com/doc]: Your query requires a full tablescan (table bb1_designelements, 78 rows affected). Use EXPLAIN to optimize your query.
> 
> I get this error on every products i tested
>