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
, andxyz
combinations of columns are leading portions of the indexyz
,y
, andz
combinations of columns are not leading portions of the index
转载于:https://blog.51cto.com/bsbforever/1610031