???????????????????
???????????? ???????[ 2012/11/26 10:13:04 ] ????????
???????????????? 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 ???
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11