???????????????????

???????????????? B ????Balance Tree?????????????????

????B ????

??????????????

?????2????????

???????????????м???

????B ???????????????????????????????????????????????????κ?????????????????????

CREATE INDEX idx_lname_pinyin ON employee(lname_pinyin);
SHOW INDEX FROM employeeG
DROP INDEX idx_lname_pinyin ON employee;

??????????????????????????????????????????????????Clustered Index??

??????????????????????????

???????????????????????б?????????????????

??????????????????????????б??????????????

??????????????

????????????????????????????????????????

??????????????????????????????????Ч??

???????????????????????????????????????????????????????????????????????????????????

????????????

CREATE INDEX idx_pinyin ON employee( lname_pinyin?? fname_pinyin);

SHOW INDEX FROM employeeG

??????????

??????? UNIQUE ????????????????????????????????????????

??????????д???????????????????????????????

?????????????????????????????У???????????????????????????????

?????????????????????????????????????????????

???????????У?????????????????????Щ?е??????????????????????????

CREATE UNIQUE INDEX idx_fname ON employee(fname);
CREATE UNIQUE INDEX idx_lname ON employee(lname);
CREATE UNIQUE INDEX idx_fullname ON employee(lname?? fname);

EXPLAIN SELECT * FROM employee WHERE lname_pinyin='wang'G

CREATE INDEX idx_lname_pinyin ON employee(lname_pinyin);
EXPLAIN SELECT * FROM employee WHERE lname_pinyin='wang'G

????EXPLAIN ??????????P100 ???