本文介绍了一个ABAP程序示例，该程序用于从CSKS表中选择最多10条记录，其中排除了某些特定条件的数据。通过使用Oracle索引提示优化了查询性能。
report z_generic_test_program .
tables: csks.
start-of-selection.
select * up to 10 rows from csks
where kokrs <> space and
kostl <> space
%_hints oracle 'index(csks"J")'.
write: / csks.
endselect.
tables: csks.
start-of-selection.
select * up to 10 rows from csks
where kokrs <> space and
kostl <> space
%_hints oracle 'index(csks"J")'.
write: / csks.
endselect.
扫一扫
1297
到【灌水乐园】发言
