UC知道关于视图执行慢
来源：百度知道 编辑：UC知道 时间：2024/05/17 01:25:19
我写了个如下的试图：
create or replace view x_foot_view as
select ajxx_tb.AJBH,ajxx_tb.NBBH,ajxx_tb.case_date,ajxx_tb.address,
ajxx_tb.case_kind_name,ajxx_tb.QTHJ_NAME,ajxx_tb.sdtd_name,ajxx_tb.account,ajxx_tb.qhdx_name,ajxx_tb.case_result_name,foot_tb.pick_person,foot_tb.foot_direct_name,foot_tb.shoe_kind_name,foot_tb.foot_kind_name,foot_tb.pick_kind_name,foot_tb.qzxt_name,foot_tb.lzxt_name,foot_tb.qzhxt_name,foot_tb.bklx_name,foot_tb.FOOT_TEXT,foot_tb.FOOT_SIZE,foot_tb.KH,foot_tb.form_kind,foot_tb.form_hg,foot_tb.age,foot_tb.high,foot_tb.CB_DATE,FOOT_TB.TEZH_IS_ELIGIBILITY,foot_tb.tezh,ajcb_tb.cbyj as CB_CBYJ,ajcb_tb.ajmc as CB_AJMC,ajcb_tb.cbbmasCB_CBBM,cbaj_oper.real_name as CB_REAL_NAME,ajcb_tb.input_date as ajcb_date,
ajcb_tb.operdm as ajcb_operdm,
ajcb_tb.cb_id,
nvl2(ajcb_tb.coding,'是','否') as ISHC,
lbxx_classify_tb.lbmc as CB_CBLB_NAME,
ajcb_oper.real_name as AJCB_REAL_NAME,
foot_tb.cb_operdm,
foot_tb.foot_no,
ajxx_tb
create or replace view x_foot_view as
select ajxx_tb.AJBH,ajxx_tb.NBBH,ajxx_tb.case_date,ajxx_tb.address,
ajxx_tb.case_kind_name,ajxx_tb.QTHJ_NAME,ajxx_tb.sdtd_name,ajxx_tb.account,ajxx_tb.qhdx_name,ajxx_tb.case_result_name,foot_tb.pick_person,foot_tb.foot_direct_name,foot_tb.shoe_kind_name,foot_tb.foot_kind_name,foot_tb.pick_kind_name,foot_tb.qzxt_name,foot_tb.lzxt_name,foot_tb.qzhxt_name,foot_tb.bklx_name,foot_tb.FOOT_TEXT,foot_tb.FOOT_SIZE,foot_tb.KH,foot_tb.form_kind,foot_tb.form_hg,foot_tb.age,foot_tb.high,foot_tb.CB_DATE,FOOT_TB.TEZH_IS_ELIGIBILITY,foot_tb.tezh,ajcb_tb.cbyj as CB_CBYJ,ajcb_tb.ajmc as CB_AJMC,ajcb_tb.cbbmasCB_CBBM,cbaj_oper.real_name as CB_REAL_NAME,ajcb_tb.input_date as ajcb_date,
ajcb_tb.operdm as ajcb_operdm,
ajcb_tb.cb_id,
nvl2(ajcb_tb.coding,'是','否') as ISHC,
lbxx_classify_tb.lbmc as CB_CBLB_NAME,
ajcb_oper.real_name as AJCB_REAL_NAME,
foot_tb.cb_operdm,
foot_tb.foot_no,
ajxx_tb
1、视图执行的时候主要过程是这样的，数据库系统先去数据库中取出视图的定义然后在用这个语句执行得到结果，所以他至少有两次磁盘I/O。
2、按照你的描述，建议你使用物化视图提高一下速度。
---
以上，希望对你有所帮助。
那得看你表的数据量和你表的定义情况