* Noamn > I have a query which was written like this > select p.id, p.name, p.money, s.name, agents.name > from projects p, status s, agents > where p.stage = 0 > and p.status = s.id > and p.agent = agents.id > order by p.name > > Despite the fact that p.name is indexed, 'explain' shows in the > extra column > 'using temporary; using filesort'. I don't understand why.
Could you show us the output of this EXPLAIN, and also SHOW CREATE TABLE on projects, status and actors? -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]