本文提供了一个具体的SQL查询示例，展示如何从“csks”表中选择最多10条记录，其中“kokrs”和“kostl”字段不为空。通过使用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.
扫一扫
1454
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
