MySQL Forums
Forum List  »  General

Re: Performance of multi-key query on large table
Posted by: Peter Brawley
Date: August 28, 2013 04:49PM

The table does not have a primary key, so it's not really a table at all.

Indexes on boolean columns carry very little information, so are useless.

Re your join: Once both tables have primary keys (SMALLINT UNSIGNED auto_increment for this table, INT UNSIGNED auto_increment for the billion-row table), a join on that PK will be fast.

Options: ReplyQuote


Subject
Written By
Posted
Re: Performance of multi-key query on large table
August 28, 2013 04:49PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.