For the purposes of discussion, our chosen index is a three-column index called IX1 created on (COLA, COLB, COLC).

为了便于讨论，我们选择的索引是一个三列索引，名为IX1，在(COLA,COLB,COLC)上创建。

youdao

Our chosen index is on (COLA, COLB, COLC), so those predicates-the first three lines in the preceding example-will be applied in that order.

我们选择的索引位于(COLA,COLB,COLC)上，因此那些谓词—上面的示例中的前三行—将以那个顺序应用。

youdao

If you want those three predicates applied in the exact order in which you code them, you must drop and re-create the index (or create a new index) on (COLA, COLC, COLB).

如果您想那三个谓词完全按照它们的编码顺序应用，则必须删除并在(COLA,COLC,COLB)上重建索引(或者创建一个新索引)。

youdao

If you want those three predicates applied in the exact order in which you code them, you must drop and re-create the index (or create a new index) on (COLA, COLC, COLB).

如果您想那三个谓词完全按照它们的编码顺序应用，则必须删除并在(COLA,COLC,COLB)上重建索引(或者创建一个新索引)。

youdao