Use EXPLAIN
Posted: Thu Mar 31, 2005 6:38 am
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
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