建立索引可以提高查询的速度:
普通查询:
# create table lianxi2 as select * from lianxi1 distributed by(id);
# select id,flag from lianxi2 where id=100;
索引查询:
# create index lianxi2_index on lianxi2(id);
# select id,flag from lianxi2 where id=100;
索引确实很快~
建立索引可以提高查询的速度:
普通查询:
# create table lianxi2 as select * from lianxi1 distributed by(id);
# select id,flag from lianxi2 where id=100;
索引查询:
# create index lianxi2_index on lianxi2(id);
# select id,flag from lianxi2 where id=100;
索引确实很快~