区分视图与索引(1) 创建视图:(以SQL语句) create view v_GoodsInfo_ClassName_UnitName [with encryption--对CREATE VIEW语句文本的项进行加密] as select GoodsID 商品编号,ClassName 类别名,Price 价格,StoreNum 库存数量,UnitName 单位,Price*StoreNum 销售金额 from GoodsInfo G1,GoodsClass G2,GoodsUnit G3 where G1.ClassID=G2.ClassID and G1.GoodsUnit=G3.U