Table TAB1 was created using the following statement: CREATE TABLE tab1 (c1 INT, c2 INT, c3 INT, c4 INT, c5 INT); If column C1 is unique and queries typically access columns C1, C2 and C3 together, which statement(s) will createindex(es) that will provide optimal query performance?()
- A、CREATE UNIQUE INDEX xtab1 ON tab1 (c1); CREATE INDEX xtab2 ON tab1 (c2) INCLUDE (c3)
- B、CREATE UNIQUE INDEX xtab1 ON tab1 (c1) INCLUDE (c2, c3)
- C、CREATE UNIQUE INDEX xtab1 ON tab1 (c3, c2, c1)
- D、CREATE UNIQUE INDEX xtab1 ON tab1 (c2) INCLUDE (c1, c3)
正确答案:B
答案解析:有

微信扫一扫手机做题