== 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[]