例子 - Single Row - id

• idx_firstname
• idx_firstname_middlename
• idx_firstname_middlename_lastname
• idx_age
• idx_aliasname_unique

  select id FROM test_isolation.user where id = 5;

  
  

例子 - Non-Unique Key Lookup - firstname

• idx_firstname
• idx_firstname_middlename
• idx_firstname_middlename_lastname
• idx_age
• idx_aliasname_unique

  select firstname FROM test_isolation.user where firstname = 'fa';

  
  

例子 - Full Index Scan - middlename

• idx_firstname
• idx_firstname_middlename
• idx_firstname_middlename_lastname
• idx_age
• idx_aliasname_unique

  select middlename FROM test_isolation.user where middlename = 'ma';

  
  

例子 - Full Index Scan - lastname

• idx_firstname
• idx_firstname_middlename
• idx_firstname_middlename_lastname
• idx_age
• idx_aliasname_unique

  select lastname FROM test_isolation.user where lastname = 'la';

  
  

例子 - Non-Unique Key Lookup - age

• idx_firstname
• idx_firstname_middlename
• idx_firstname_middlename_lastname
• idx_age

• idx_aliasname_unique

  select lastname FROM test_isolation.user where age = 10;

  
  

  例子 - Single Row - aliasname

• idx_firstname

• idx_firstname_middlename
• idx_firstname_middlename_lastname
• idx_age
• idx_aliasname_unique

  select aliasname FROM test_isolation.user where aliasname = 'aa';

  
  

例子 - Full Table Scan - remark

• idx_firstname
• idx_firstname_middlename
• idx_firstname_middlename_lastname
• idx_age
• idx_aliasname_unique

  select lastname FROM test_isolation.user where remark = 'ra';

  
  

例子 - Non-Unique Key Lookup - firstname,middlename

• idx_firstname
• idx_firstname_middlename
• idx_firstname_middlename_lastname
• idx_age
• idx_aliasname_unique

  select firstname,middlename FROM test_isolation.user where firstname = 'fa'and middlename = 'ma';

  
  

例子 - Non-Unique Key Lookup - firstname,middlename,lastname

• idx_firstname
• idx_firstname_middlename
• idx_firstname_middlename_lastname
• idx_age
• idx_aliasname_unique

  select firstname,middlename,lastname FROM test_isolation.user where firstname = 'fa'and middlename = 'ma' and lastname = 'la';

  
  

例子 - Non-Unique Key Lookup - firstname,middlename,lastname,age

• idx_firstname
• idx_firstname_middlename
• idx_firstname_middlename_lastname
• idx_age

• idx_aliasname_unique

  select firstname,middlename,lastname,age FROM test_isolation.user where firstname = 'fa'and middlename = 'ma' and lastname = 'la' and age = 10;

  
  

  例子 - Non-Unique Key Lookup - firstname,middlename,lastname,age,remark

• idx_firstname

• idx_firstname_middlename
• idx_firstname_middlename_lastname
• idx_age

• idx_aliasname_unique

  select firstname,middlename,lastname,age,remark FROM test_isolation.user where firstname = 'fa'and middlename = 'ma' and lastname = 'la' and age = 10;

  
  

  例子 - Non-Unique Key Lookup - firstname,middlename,lastname,age,remark

• idx_firstname

• idx_firstname_middlename
• idx_firstname_middlename_lastname
• idx_age
• idx_aliasname_unique

  select firstname,middlename,lastname,age,remark FROM test_isolation.user where firstname = 'fa'and middlename = 'ma' and lastname = 'la' and age = 10 and remark = 'ra';

  
  

例子 - Non-Unique Key Lookup - firstname,lastname

• idx_firstname
• idx_firstname_middlename
• idx_firstname_middlename_lastname
• idx_age
• idx_aliasname_unique

  select firstname,lastname FROM test_isolation.user where firstname = 'fa' and lastname = 'la';

  
  

例子 - Non-Unique Key Lookup - firstname,remark

• idx_firstname
• idx_firstname_middlename
• idx_firstname_middlename_lastname
• idx_age
• idx_aliasname_unique

  select firstname,remark FROM test_isolation.user where firstname = 'fa' and remark = 'ra';

  
  

例子 - Full Index Scan - middlename,lastname

• idx_firstname
• idx_firstname_middlename
• idx_firstname_middlename_lastname
• idx_age
• idx_aliasname_unique

  select middlename,lastname FROM test_isolation.user where middlename = 'ma' and lastname = 'la';

  
  

例子 - Non-Unique Key Lookup - firstname,age

• idx_firstname
• idx_firstname_middlename
• idx_firstname_middlename_lastname
• idx_age
• idx_aliasname_unique

  select firstname,age FROM test_isolation.user where firstname = 'fa' and age = '10';