Indexing

An ideal query runs against indexed columns. Querying against indexed columns increases the speed at which Service Manager can receive data. However, adding too many indexes adds a performance cost to inserting (adding) new records as well as updating or deleting existing ones. Indexes also require additional storage space.

Your database administrator will weigh the potential benefit of indexing your queries against the cost of increased write times (insertions and updates). Typically, your database administrator may want to index any query that many people access or that gets run frequently. You may want to index tables that are part of the following Service Manager frequently-used queries:

  • Public favorites
  • Commonly-used forms containing Format controls
  • Fills
  • Drop-downs (combo boxes)
  • Global lists
  • Background processes

Related concepts

Query operators
Function usage
Variable usage and null values