表employee有5个字段，应该为它创建怎样的索引？

admin

表employee有5个字段，employee_id bigint primary key,name varchar(32),sex int ,create_date long,salary decimal;

对于查询语句模式[select * from employee where create_date<? and salary between ? and ?]

应该为它创建怎样的索引？

zxjc

以employ_id来进行创建索引。

WR

create index employee on create_date;

一个人的时光

create index emp_index1 on employee(create_date,salary);

zhangjialong

-- Create table

create table EMPLOYEE
(
  ID          NUMBER not null,
  NAME        VARCHAR2(32),
  SEX         INTEGER,
  CREATE_DATE NUMBER,
  SALARY      INTEGER
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
-- Create/Recreate primary, unique and foreign key constraints
alter table EMPLOYEE
  add constraint EID primary key (ID)
  using index
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

--建立索引
create or replace view myview as
select create_date,salary from employee
--基于索引查询数据

select * from myview where create_date<20000 and salary between 1000 and 3000

gaoye

创建复合索引

复合索引是基于两列或是多列的索引，在同一张表上可以有多个索引，但是要求列的组合必须不同。

分别在字段 create_date 和字段 salary 上创建索引

Sarbr

create index id on employee_id;

梦紫菱0124

答：符合索引，在create_date和salary上同时加上索引

刘瑞

liufangyuan

--建立索引
create or replace view myview as
select create_date,salary from employee
--基于索引查询数据

select * from myview where create_date<20000 and salary between 1000 and 3000

完整代码：

-- Create table
create table EMPLOYEE
(
  ID          NUMBER not null,
  NAME        VARCHAR2(32),
  SEX         INTEGER,
  CREATE_DATE NUMBER,
  SALARY      INTEGER
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
-- Create/Recreate primary, unique and foreign key constraints
alter table EMPLOYEE
  add constraint EID primary key (ID)
  using index
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

--建立索引
create or replace view myview as
select create_date,salary from employee
--基于索引查询数据

select * from myview where create_date<20000 and salary between 1000 and 3000

XIAOC

create index aa on employee(create_date);

Yc

create index employee_index on employee (create_date,salary,employee_id)

740317431

创建复合索引

create index mixIndex on employee (create_date,salary) 

王之神判

复合索引

zxx

为create_date,salary列建立复合索引

wulinan

创建复合索引 create index mixIndex on employee (create_date,salary)

L J

在 字段 create_date 和 字段 salary

创建  复合索引

yue

函数索引