是用 存储过程 还是 视图 ？？？

[htht66]

下面是查询公司的基本信息，是用存储过程好，还是视图好呢？
这一点很迷惑，希望大家多多指教。

select comp_id, comp_name,city_name+coun_name as address ,comp_homepage,comp_email,comp_tel

from tbl_company comp

join
(select city_name,city_id from tbl_city) city
on comp.comp_address_city=city.city_Id

join
(select coun_id,coun_name from tbl_country) coun
on comp.comp_address_county=coun.coun_id

[Limpire]

view

[htht66]

为什么？
使用视图有哪些有点呢？

[Limpire]

存储过程返回记录集处理起来麻烦

[htht66]

@Limpire(昨夜小楼)

但是使用视图会占用一些数据库资源（空间）

[Limpire]

除非你建索引视图，否则相当于只是保存了一个查询批

[htht66]

3 Q