List:General Discussion« Previous MessageNext Message »
From:Rhino Date:September 22 2004 10:40pm
Subject:Re: help!!!!!!!!!!
View as plain text  
You're probably going to need to create some indexes on your tables. If you
have no indexes, MySQL can only do a full tablescan.

See the manual for the syntax of the statement that creates an index.


----- Original Message ----- 
From: "Sven" <>
To: <mysql@stripped>
Sent: Sunday, September 19, 2004 1:50 AM
Subject: help!!!!!!!!!!

Warning: mysql_query() []: 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

help!!!!!!!!!!Sven22 Sep
  • Re: help!!!!!!!!!!Eric Bergen23 Sep
  • Re: help!!!!!!!!!!Rhino23 Sep