DBA App Indexes App Indexes viewAdministration DBA App Indexes App Indexes view
The App Indexes view provides an audit of your database indexes.
This option is not available if your N4 TOS is hosted by Kaleris.
The values in the Diff column indicate the status of the index:
OK: The database has the required index.
DUPLICATED: The index has double declaration. This does not impact functionality or performance. Send a low priority request to Navis to remove the duplication in a future N4 release.
EXTRA: The database has it, but N4 does not require it. You can drop these, but consult your database administrator and Navis first.
MISSED: N4 requires the index, but the database does not have it. You need to add a MISSED or MISSED FK index as soon as possible as it could play a role in performance.
MISSED FK (foreign key): N4 requires the index, but there are not any on this column.
To add an index:
Select the MISSED index.
Go to the Actions menu.
Select Create Index.
Adding an index can take several minutes. It is best to do this during off peak hours.
To drop an index:
Select the EXTRA index.
Go to the Actions menu.
Select Drop Index.
The Database Performance Management privilege (on page 1) controls access to this view.
Gathering fragmentation information (SQL Server)
You can also gather fragmentation information from the App Indexes view. Before deciding which defragmentation method to use, you need to analyze the index to determine the degree of fragmentation. The Gather fragmentation info action detects fragmentation in a specific index, all indexes on a table or indexed view, or all indexes in a database. This option is available only with SQL Server.
Because this action to gather fragmentation information is time and resource consuming, you should run this during off-peak hours. The application will not be responsive for several minutes.
To gather fragmentation information:
Go to the Actions menu.
Select Gather fragmentation info.
Choose Yes to proceed.
After the process is complete, the Fragmentation column displays the fragmentation percentage:
Red: 75% or greater fragmented
Orange: Between 30% and 75% fragmented
Yellow: Between 5% and 30% fragmented
White: Less than 5% fragmented
|
Short Label |
Long Label |
Description |
|---|---|---|
|
Cardinality |
Cardinality |
Number of unique values |
|
Column Name |
Column Name |
Name of the table column. |
|
Diff |
Difference |
Status of the index:
|
|
Fragmentation |
Fragmentation Ratio |
Percentage of index fragmentation. |
|
Generated |
Generated |
Indicates True if the index was generated by N4. |
|
Index Name |
Index Name |
Name of the index. |
|
Index Type |
Index Type |
The index type:
|
|
Last Analyzed |
Last Analyzed |
The last time when the index statistics were gathered. |
|
Multicolumn |
Multicolumn |
Indicates True if the index covers more than one column. |
|
Oper. Status |
Operation Status on Spatial Index |
Status of the operation on the spatial index. The normal status is Valid. |
|
Position |
Position |
Indicates the indexed column position in a multicolumn index, or 1 for non-multicolumn index |
|
Row Number |
Row Number |
Approximate number of rows in the index as indicated by the statistics table. |
|
Status |
Spatial Index Status |
Status of spatial index. The normal status is Valid. |
|
Table name |
Table Name |
The table for which the index was created. |
|
Tablespace name |
Tablespace Name |
Indicates how the database objects are distributed on the file system. |
|
Uniqueness |
Uniqueness |
Indicates if the index is unique, where each value in the key column is unique.
|
|
Usage |
Usage Count |
Indicates whether the indexes are used. Useful in gathering information about unused indexes. The values are:
|