Today I read about a blog explaining very detailedly on how to correctly use the key words FOR ALL ENTRIES IN.

The link is :

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.


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


  1. Leetcode 5016. 删除最外层的括号
  2. Hive的JDBC
  3. Lunx下 怎样启动和关闭oracle数据库
  4. Oracle RAC时间同步(NTP/CTSS)
  5. python3使用requests模块完成get/post/代理/自定义header/自定义Cookie
  6. Linux使用ntpdate和ntpd进行时间同步
  7. CentOS下安装mysql5.7和mysql8.x
  8. nodejs安装 淘宝镜像
  9. PAT-GPLT训练集 L1-043 阅览室
  10. linux的命令: