看到经常有人问此问题!doc的原话,看到了随手记录下!
[@more@]A leading portion of an index is a set of one or more columns that were specified first and consecutively in the list of columns in the CREATE INDEX statement that created the index. Consider this CREATE INDEX statement:
CREATE INDEX comp_ind ON table1(x, y, z);
x,xy, andxyzcombinations of columns are leading portions of the indexyz,y, andzcombinations of columns are not leading portions of the index
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/19602/viewspace-1002846/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/19602/viewspace-1002846/
本文详细解释了数据库索引中的前缀概念,即在创建索引时首先连续指定的一组或多组列。通过示例说明了哪些列组合构成了索引的前缀部分。
?&spm=1001.2101.3001.5002&articleId=100209857&d=1&t=3&u=8193fc1abcfa44168340f56dbe630970)

被折叠的 条评论
为什么被折叠?



