数据库优化

create table book(
id number(20)primary key,
name varchar2(20)not null,
address varchar2(20)not null,
marning varchar2(20)not null
);

插入的字段

insert into book(id,name,address,marning) values(1,'英语','英国',100)
insert into book(id,name,address,marning) values(2,'法语','法国',200)
insert into book(id,name,address,marning) values(3,'韩语','韩国',300)
insert into book(id,name,address,marning) values(4,'日语','日本',400)
insert into book(id,name,address,marning)values(5,'奥语','澳洲','600')

如果想提升效率怎么办？我说的是真对查询？

Select *from book   //它所消耗的时间 0.031秒
Select id,name,name,address,marning from book //它消耗的时间0.031秒
select b.id,b.name,b.address,b.marning from book b //他消耗0.032

select id,name, address,marning from book where name='英语'//0.063秒
select*from book where name like'%英语%'//0.016秒