Re: Performance of multi-key query on large table
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.
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.