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