Oracle视图走索引

前端之家收集整理的这篇文章主要介绍了Oracle视图走索引前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

/*+index(v_stock_info_terminal.sitem ST_SUMMARY_ITEM_N7)/ 视图名称.视图内表的别名 视图内表的字段对应的索引 select /*+index(v_stock_info_terminal.sitem ST_SUMMARY_ITEM_N7)index(v_stock_info_terminal.sitem ST_SUMMARY_ITEM_N1)*/ * from app_scmwms.v_stock_info_terminal t where t.WAREHOUSEID = '1EACA5B74218E4BBE0538A111E0AE414' and t.Box_no = '320067021502030044';

猜你在找的Oracle相关文章