EXPLAIN - Question..

2003-07-23 Thread Tom O'Neill \(MySQL User\)
Hello everyone. I have copied the results from and explain on a query that I want to use. And I am wondering if anyone could tell me if these results are bad or good? If everything below is coming up garbled for you I will basically I am using 7 tables and the rows for 6 of the seven are 1 and t

Re: EXPLAIN question

2001-07-20 Thread Dan Nelson
In the last episode (Jul 20), Ravi Raman said: > ok, first actual question to the list, hope someone can help: > the following query - > > select pn.number, c.ID, c.cost, c.days_valid, c.description from > pinnumbers pn, cardtype c where pn.cardtypeID = c.ID and pn.tmaster = 0 > order by c.ID, pn.

EXPLAIN question

2001-07-20 Thread Ravi Raman
hi. ok, first actual question to the list, hope someone can help: the following query - select pn.number, c.ID, c.cost, c.days_valid, c.description from pinnumbers pn,