[
https://issues.apache.org/jira/browse/DERBY-6375?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13790113#comment-13790113
]
Knut Anders Hatlen commented on DERBY-6375:
-------------------------------------------
Thanks, Kim! I think the placement is fine, but it might be better to have it a
little earlier. For example, I think applications that suffer from deadlocks
should verify that they have the appropriate indexes before they start using
table locks, so maybe swap those two paragraphs? I liked the cross reference to
the Tuning Guide. It seems to contain all the useful details about what
"appropriate use of indexes" means, so that we can keep the Developer's Guide
topic short.
> Suggest use of indexes in devguide's deadlock avoidance topic
> -------------------------------------------------------------
>
> Key: DERBY-6375
> URL: https://issues.apache.org/jira/browse/DERBY-6375
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.10.1.1
> Reporter: Knut Anders Hatlen
> Assignee: Kim Haase
> Attachments: cdevconcepts53677.html, DERBY-6375.diff
>
>
> The developer's guide has a topic called Avoiding deadlocks. That topic
> should also mention that reasonable indexes may help prevent deadlocks since
> they make table scans less likely and reduce the number of locks obtained.
--
This message was sent by Atlassian JIRA
(v6.1#6144)
