system.catalog where INDEX_TYPE is not null;”
Name of the index
Name of the parent data table of index
Index States (Abbreviation stored in SYSTEM.CATALOG, states
in bold are available to client too):-
(Below paragraph is from
DISABLE will cause the no
further index maintenance to be performed on the index and it will no longer be
considered for use in queries.
REBUILD will completely rebuild
the index and upon completion will enable the index to be used in queries
BUILDING will partially rebuild the
index from the last disabled timestamp and upon completion.
cause the index to no longer be considered for use in queries, however index
maintenance will continue to be performed.
cause the index to again be considered for use in queries.
Note that a disabled index must be rebuild and
cannot be set as USABLE
It is the timestamp at which index is disabled. It will be 0
, if the index is active or disabled by client manually and will non-zero when
index is disabled during write failures.
(default 10 seconds)