oracle：指定索引

-- Create table
create table TEST
(
  ID  NUMBER,
  NUM NUMBER
);

create index INDEX_TEST_ID_NUM on TEST (ID, NUM)
  tablespace TEST
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

select /*+ index(t, index_test_id_num)*/ t.id, t.num from test t