For all entries in
Today I read about a blog explaining very detailedly on how to correctly use the key words FOR ALL ENTRIES IN.
The link is : http://www.cnblogs.com/panjun-Donet/archive/2010/10/20/1857100.html.
Recollection: this keywords feature is used when two tables can't be joined to fetch data, such as a cluster table BSEG and a transparent table BSIS, which two are in a sense intersected. Therefore, if we want to fetch data from BSEG and BSIS, we can first put the BSIS data into an internal table called IT_BSIS, then we use SELECT statements to get data from BSEG by using FOR ALL ENTRIES IN IT_BSIS where BUKRS = IT_BSIS-BUKRS and ...
In above situation, we successfully completed the manipulation of fetching data from two intersected tables (Specificly refer to BSEG and BSIS).
Using FOR ALL ENTRIES IN feature is kind of disturbing, or rather wasting memory, sometimes. Especially when there are a large amount of data in the IT_BSIS table, and in this case the actual manipulation is getting all the conditions together and separating them with OR, and the whole condition will seem too abundant. It is better to consider if vital before we directly use this feature.
A necessary reminder is that Check the IT_BSIS table before we use this feature, or else the system might go dumped due to high load of data processing.
最新文章
- JQuery Datatables Columns API 参数详细说明
- dbutils基本使用
- AX7: Get started developing
- 解决myeclipse过期问题
- hdu1250(Java）大数相加的问题
- ubuntu vim之php函数提示
- poj 3692 Kindergarten （最大独立集之逆匹配）
- iOS文件保存策略
- 如何在Java中调用Python代码
- channel.go
- 小程序顶部navbar（非Slider）
- windows系统开启虚拟化
- Cocos Creator学习六：加载/释放图片资源
- 解决命名空间“System.Web.Mvc”中不存在类型或命名空间名称“Ajax”(是否缺少程序集引用?)
- ES6 迭代器和生成器
- pyqt5 -——介绍及和pycharm的环境搭建
- 通过script src引入ElementUI时，使用语句：window.ELEMENT.MessageBox.alert(xxx) 调用弹出框
- mysql5.7 安装错误解决
- 牛客网NOIP赛前集训营-提高组（第八场）-B-推箱子[最短路优化建图]
- Daily Scrum NO.2