SQL索引和视图

-- 创建emp表ename字段的索引
create index i_emp_index on emp(ename);


-- 删掉索引


drop index i_emp_index;


-- 创建一个视图


create view v_emp as select empno,ename,job from emp;


select * from v_emp limit 1;


insert into v_emp values (8888,'zs','clerk');


-- 视图 可以简化查询语句
-- 查询员工表中工资最高的和最低的员工信息
create or replace view v_emp1 as select max(sal)as max_sal, min(sal) as min_sal from emp;


-- 子查询


select * from emp where sal in (select max_sal from v_emp1) or sal in (select min_sal from v_emp1);