Page 1 of 1

Use EXPLAIN

Posted: Thu Mar 31, 2005 6:38 am
by navid
hi
i have problem by my web site.
in my web site has a long database.

when i connected to my database.
i get 1 error
this error is "Warning: mysql_query(): Your query requires a full tablescan (table items, 982 rows affected). Use EXPLAIN to optimize your query. in E:\.... on line... ".

is any help to me?
thanks

Posted: Thu Mar 31, 2005 6:48 am
by n00b Saibot
Post your table structure and query your are trying...

Posted: Thu Mar 31, 2005 12:23 pm
by feyd