Home MySQL: Is a primary key created automatically when creating a temporary table?
Reply: 0

MySQL: Is a primary key created automatically when creating a temporary table?

user444
1#
user444 Published in April 22, 2018, 6:00 pm

I have a query that is taking quite a long time (11 million or so observations), and three joins (I can't stop it to check). One of the joins is with a temporary table.

When I create a temporary table using data from a table that has a primary key within it, will the new table carry over the indexing, or do I have to explicitly create an index in the new temporary table (with the primary key from the parent table)?

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.389559 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO