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.
最新文章
- 让IE8支持HTML5及canvas功能！chart.js图表绘制工具库IE8上兼容方案
- WPF TabControl 模拟动画
- UI优化
- JS之事件（一）
- Protege汉字不能正常显示问题
- centos6.5安装配置zabbix3.0.3
- location传值
- 遍历元素绑定事件时作用域是怎么回事啊，为什么要用this关键字，而直接使用元素本身就不行？
- Parallelogram Counting（平行四边形个数，思维转化）
- HDU 4982 Goffi and Squary Partition（推理）
- cocos2d-html5基金会
- windows服务-log4net的使用
- Kubernetes - 腾讯蓝鲸配置平台(CMDB)开源版部署
- 借鉴Glide思想二次封装Fresco
- 创业维艰-->>书摘+乱七八糟
- （转）fabric 一个链码如何调用另一个链码
- linux 如何释放缓存
- servlet编码问题
- Redis学习之实现优先级消息队列
- Java基础——Servlet（五）