BINARY SEARCH in read table statement
2024-10-19 13:32:15
1.for standard table, it must be sorted by search key.
2.for sorted table , binary search is used automatically when searching with/include table key.
Note:with a binary search (addition BINARY SEARCH is used for standard tables, automatically for sorted tables), if there are several hits (because of an incompletely specified search key or because there are duplicate entries in the table), then the first hit in terms of the sequence of the rows is always returned, that is, the row with the smallest index.
using binary search,if there is no records hitted , then sy-subrc is set to 4, sy-tabix is set to 1,
if there is no record hitted and the end of the table was reached, sy-subrc is set to 8, sy-tabix is set to lines of table + 1.
最新文章
- JAVA构造函数(方法)与方法是啥意思
- 利用SQLiteOpenHelper来管理SQLite数据库 (转)
- js 键盘移动div、img对象
- react编译器jsxTransformer,babel
- C#操作Word生成目录
- 如何同时启动多个Tomcat服务器
- NetAdvantage
- 【poj3734】矩阵乘法求解
- [Regular Expressions] Introduction
- 怎样安装配置tomcat 8
- 认知服务调用如何使用图片的DataURL
- keepalived+nginx负载均衡+ApacheWeb实现高可用
- __x__(30)0908第五天__导航条的练习 <;div>;版本
- Spring data Jpa 分页从1开始,查询方法兼容 Mybatis,分页参数兼容Jqgrid
- (笔记)AT91SAM9260的启动过程详细解说
- Win7下设置护眼的电脑豆沙绿界面
- 【C++】wchar、char格式化符输出
- (转)Maven学习-处理资源文件
- 运行Chromium浏览器无法登录谷歌账号因为缺少google api密钥
- COLLATE CHINESE_PRC_CI_AS_WS 的含义