Use EXPLAIN

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
navid
Forum Commoner
Posts: 68
Joined: Tue Sep 24, 2002 3:14 am
Location: iran

Use EXPLAIN

Post 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
User avatar
n00b Saibot
DevNet Resident
Posts: 1452
Joined: Fri Dec 24, 2004 2:59 am
Location: Lucknow, UP, India
Contact:

Post by n00b Saibot »

Post your table structure and query your are trying...
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

Post Reply