Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. coop207

    Strange results from joining different table sizes

    Thank you for answering my question. I have just been running separate scripts for each join. I didn't know I could put all of the joins in one big script. The explain says it is doing a product join for the 300 row table. That may be the problem. The product join may be too slow. Thank you
  2. coop207

    Strange results from joining different table sizes

    Hello, I have a very large table (over 4.6 million records) and am joining a table with 300 rows to it and a table with 800 rows to it. All three tables have two fields and I have created a unique primary index on the two fields. I ran the first join which took approximately 3 minutes...

Part and Inventory Search

Back
Top