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.
28 lines
1.1 KiB
Plaintext
28 lines
1.1 KiB
Plaintext
== Why is this an issue?
|
|
|
|
The performance of queries made against large database tables is considerably improved when the columns in the ``++where++`` clause are indexed. If all the columns in the ``++where++`` clause are included in an index, then the selection can be made directly against the index, but using even a single indexed column can improve performance. Therefore, indexes should be created on large tables to improve query performance.
|
|
|
|
ifdef::env-github,rspecator-view[]
|
|
|
|
'''
|
|
== Implementation Specification
|
|
(visible only on this page)
|
|
|
|
=== Message
|
|
|
|
Add an index on at least one of the columns in this query.
|
|
|
|
|
|
'''
|
|
== Comments And Links
|
|
(visible only on this page)
|
|
|
|
=== on 25 Aug 2014, 07:32:20 Freddy Mallet wrote:
|
|
@Ann, according to this RSPEC, the COBOL language is covered but I don't see the relating Jira ticket in the COBOL project ?
|
|
|
|
=== on 25 Aug 2014, 18:59:52 Ann Campbell wrote:
|
|
\[~freddy.mallet] this is our beta rule that's we're waiting on client feedback for. It was initially implemented w/out a ticket, so there's not one to tie it to. I suppose we could create a ticket to update the description...?
|
|
|
|
|
|
endif::env-github,rspecator-view[]
|