首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > 其他数据库 >

转:什么是index的leading column(目录的前导列)

2013-01-01 
转:什么是index的leading column(索引的前导列)?A leading portion of an index is a set of one or more

转:什么是index的leading column(索引的前导列)?
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, and xyz combinations of columns are leading portions of the index
yz, y, and z combinations of columns are not leading portions of the index

热点排行