When to Index - Firebird

Some indexes will suggest themselves to you during the initial design period—typically for requirements that you know will need particular sortings, groupings, and evaluations. It is very good practice to be conservative about creating indexes until it becomes clear that they might be beneficial. It is a rewarding strategy to defer the creation of doubtful indexes until after a point in development where you have good samplings of typical test data and an awareness of which operations are too slow.

The benefits of deferred index design include

  • Reduction of “performance fogging” that can interfere with the functional integrity testing
  • Faster identification of the real sources of bottlenecks
  • Avoidance of unnecessary or inefficient indexing

All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Firebird Topics