创建Outline的语句如下：CREATE OUTLINE ot1 ON "SELECT/*+ index(t1 ix1)*/ C1,C2,C3 FROM T1 WHERE C1=1 ORDER BY 2";以下哪个语句可以命中该Outline？

培训 & 考证
#1

创建Outline的语句如下：CREATE OUTLINE ot1 ON “SELECT/+ index(t1 ix1)/ C1,C2,C3 FROM T1 WHERE C1=1 ORDER BY 2”;以下哪个语句可以命中该Outline？

A. SELECT C1,C2,C3 FROM T1 WHERE C1=1 ORDER BY 1

B. SELECT C2,C1,C3 FROM T1 WHERE C1=2 ORDER BY 2

C. SELECT C2,C1,C3 FROM T1 WHERE C1=1 ORDER BY 1

D. SELECT C1,C2,C3 FROM T1 WHERE C1=2 ORDER BY 2