ITPub博客

首页 > 数据库 > 数据库开发技术 > 什么是index的leading column(索引的前导列)?

什么是index的leading column(索引的前导列)?

原创 数据库开发技术 作者:warehouse 时间:2008-04-22 18:30:49 0 删除 编辑

看到经常有人问此问题!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, 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

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/19602/viewspace-1002846/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2007-12-07

  • 博文量
    717
  • 访问量
    5115400