[DERBY-6375] Suggest use of indexes in devguide's deadlock avoidance topic

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.10.1.1
• Fix Version/s: 10.10.2.0, 10.11.1.1
• Component/s: Documentation
• Assignee: Camilla Haase
• Reporter: Knut Anders Hatlen
• Created: 08/Oct/13 15:18
• Updated: 16/Apr/14 02:41
• Resolved: 10/Oct/13 15:06

Description

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.

Issue Links

• relates to: DERBY-6372 ERROR 40001: A lock could not be obtained due to a deadlock