Will a composed index help me?
Posted by:
Alex P
Date: April 09, 2009 12:36AM
Facts:
1. Table T1 InnoDB with fields F11 (10 million rows corresponding to each different value of field F11) and F12 (of the 10 million probably 2 million corresponding to each F12).
2. Table T2 InnoDB (small table) with field F21
3. SQL clause which selects from T1 and T2, filtered on F11 and joined on F12 = F21
4. I already have an index for T1 on field F11
Question:
Would a composed index (F11, F12) on table T1 help me?
Subject
Views
Written By
Posted
Will a composed index help me?
4254
April 09, 2009 12:36AM
2312
April 10, 2009 10:31AM
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.