1:考虑如下数据表和查询,如何添加索引功能提高查询速度?( ) Create table mytable( Id int, Name char(100), Address1 varchar(100), Address2 varchar(100), Zipcode varshar(10), Sity varchar(50), Province varchar(2) ) Select id, varchar From mytable Where id between 0 and 100 Order by name, zipcode;
A:给Zipcode添加全文的索引
B:给Name添加索引
C:给Id添加索引,然后给Name和Zipcode分别添加索引
D:给id添加索引
(责任编辑:admin)要这答案加QQ:800020900 或加微信:vq800020900 获取