1.T-code:SE11选择需要创建索引的表,点击①,在选择②,新建索引。
2.进入后,按所需的字段创建索引,保存激活。
3.索引的使用,在SQL语句中按设置的索引字段顺序,查询数据库表,举个例子。
例子的索引两个,分别为: werks/matnr/ersda 与 werks/matnr/laeda
SELECT a~matnr AS matnr "产品id
a~meins "单位
INTO CORRESPONDING FIELDS OF TABLE lt_marc
FROM mara AS a
INNER JOIN marc AS c
ON c~matnr = a~matnr
INNER JOIN msta AS s
ON c~werks = s~werks AND c~matnr = s~matnr
WHERE ( a~lvorm = 'X' OR c~lvorm = 'X' ) "删除标记
AND c~werks = '5201' "工厂
AND ( s~ersda BETWEEN l_sdate AND l_edate "创建日期
OR s~laeda BETWEEN l_sdate AND l_edate ). "修改日期.
Ps. 可能会出现‘数据库系统 XXX-YYY 中索引 ORACLE 不存在’。
解决方案:T-code:SE14进入后,选择‘索引…’->‘创建数据库索引’