w
womble
JOIN t2 ON t1.id=t2.id AND t1.date=t2.date
C
Chad Birch
JOIN t2 ON (t2.id = t1.id AND t2.date = t1.date)
t
tschumann
SELECT *
FROM t1
JOIN t2 USING (id, date)
perhaps you'll need to use INNER JOIN or where t2.id is not null if you want results only matching both conditions
Basically, slowness is because concrete calculates new values that has no indexes so direct conditions should be faster. if even this query would be slow again, check is indexes exists, and sometimes creation one index for 2 fields also makes sense.
Follow WeChat
Success story sharing
Want to stay one step ahead of the latest teleworks?
Subscribe Now相似问题
- What is the difference between "INNER JOIN" and "OUTER JOIN"?
- How can I find all the tables in MySQL with specific column names in them?
- Can I concatenate multiple MySQL rows into one field?
- Should I use the datetime or timestamp data type in MySQL?
- How can I do 'insert if not exists' in MySQL?
- How do I perform the SQL Join equivalent in MongoDB?
- LEFT OUTER JOIN in LINQ
- Installing specific package version with pip
- How do I import an SQL file using the command line in MySQL?
