Processing Issues

Processing issues may be related to loads, queries, indexes, and table access.

• Too Many Indexes on Table
  Issues may occur when a table has too many indexes.
• Unexpectedly Long Loads or Queries
  Long loads or queries may cause issues.
• Load Fails on Number of Unique Values
  The number of unique values in a query may cause issues.
• Cannot Write to a Locked Table
  Locked tables may cause issues.
• Managing Write Lock Contention on a Table
  High contention for write locks on a table used by multiple users can impact processing, if most of the transactions can obtain the lock.
• Checkpoint Hints
  The default values for checkpoint time and recovery time are sufficient and in most cases do not need to be changed.