16f6c0aecf
Inline adoc files when they are included exactly once. Also fix language tags because this inlining gives us better information on what language the code is written in.
26 lines
629 B
Plaintext
26 lines
629 B
Plaintext
== Why is this an issue?
|
|
|
|
The ``++result_cache++`` Oracle hint can vastly improve performance, but it comes at the cost of extra memory consumption, so one should double-check that the gain in performance is significant, and avoid overusing this feature in general.
|
|
|
|
|
|
=== Noncompliant code example
|
|
|
|
[source,sql]
|
|
----
|
|
SELECT /*+ result_cache */ * FROM DUAL; -- Noncompliant
|
|
----
|
|
|
|
|
|
ifdef::env-github,rspecator-view[]
|
|
|
|
'''
|
|
== Implementation Specification
|
|
(visible only on this page)
|
|
|
|
=== Message
|
|
|
|
Review this result_cache hint usage to ensure the performance benefits outweigh the memory cost.
|
|
|
|
|
|
endif::env-github,rspecator-view[]
|