List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:July 20 2001 9:41pm
Subject:Re: EXPLAIN question
View as plain text  
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.number
>
> returns: 55033 rows in set (4 min 10.11 sec)

Are pn.cardtypeID and c.ID declared the same?  That can sometimes cause
problems.

-- 
	Dan Nelson
	dnelson@stripped
Thread
Bug report: FULLTEXT index corrupts the index with too many TEXT fieldsCarsten Gehling16 Jul
  • Re: Bug report: FULLTEXT index corrupts the index with too many TEXT fieldsSergei Golubchik16 Jul
  • Re: Bug report: FULLTEXT index corrupts the index with too many TEXT fieldsCarsten Gehling19 Jul
    • Re: Bug report: FULLTEXT index corrupts the index with too many TEXT fieldsSergei Golubchik19 Jul
      • SV: Bug report: FULLTEXT index corrupts the index with too many TEXT fieldsMartin Larsen19 Jul
  • Solution (but only a temporary one) Re: Bug report: FULLTEXT index corrupts the index with too many TEXT fieldsCarsten Gehling19 Jul
  • Re: Bug report: FULLTEXT index corrupts the index with too many TEXT fieldsCarsten Gehling20 Jul
    • Re: Bug report: FULLTEXT index corrupts the index with too many TEXT fieldsSinisa Milivojevic20 Jul
    • Re: Bug report: FULLTEXT index corrupts the index with too many TEXT fieldsSergei Golubchik20 Jul
  • Re: Bug report: FULLTEXT index corrupts the index with too many TEXT fieldsCarsten Gehling20 Jul
  • Re: Bug report: FULLTEXT index corrupts the index with too many TEXT fieldsFournier Jocelyn [Presence-PC]20 Jul
  • Re: Bug report: FULLTEXT index corrupts the index with too many TEXT fieldsCarsten Gehling20 Jul
    • Re: Bug report: FULLTEXT index corrupts the index with too many TEXT fieldsSergei Golubchik20 Jul
      • The Best PlatformDave Carter20 Jul
        • EXPLAIN questionRavi Raman20 Jul
          • Re: EXPLAIN questionDan Nelson20 Jul
  • Re: Bug report: FULLTEXT index corrupts the index with too many TEXT fieldsCarsten Gehling29 Jul
    • Re: Bug report: FULLTEXT index corrupts the index with too many TEXT fieldsSinisa Milivojevic29 Jul
RE: Bug report: FULLTEXT index corrupts the index with too many TEXT fieldsSimon Green20 Jul
  • Re: Bug report: FULLTEXT index corrupts the index with too many TEXT fieldsFournier Jocelyn [Presence-PC]20 Jul