Edit Indices
Indexes are automatically maintained during operations such as: insert, delete, update... Over time, indexes can become fragmented (scattered) because the logical sequence of leaves based on the key value does not match the physical sequence in the index itself. If the fragmentation is large, it can reduce the performance and responsiveness of the program.
The Edit Indices panel allows managing index fragmentation, editing missing/redundant indexes, creating primary keys, and reviewing logs.
The functionality is accessed on Performance panel in Administration panel.
The form is made up of certain panels, which are described below.
- Databases - displays a list of all databases on the server for which we want to manage indexes.
- Fragmentation - allows for reviewing index fragmentation and performing defragmentation.
- Missing/Redundant Indexes - allows seraching, creating missing indices and and preview redundant indexes.
- Primary Key - allows searching and creating primary keys in databases.
- Logs (incl upgrades) - gathers errors during the upgrade and errors when creating (non-creating) primary keys from the previous tab which are recorded in the logs.