|
|
|
There are multiple ways to create indexes in the database:
Dovetail SchemaEditor does not track or maintain indexes that do not exist in the metadata (ADP) tables.
For example, if a column is being dropped by Dovetail SchemaEditor, and there is an index on that column, and that index exists in the metadata tables, then Dovetail SchemaEditor is aware of that index, and thus can validate the drop operation and its effect on the index. If that index was created using database tools directly, then Dovetail SchemaEditor is not aware of that index, thus it will not perform any validation.
Whenever a table is modified, existing indexes on that table are left as-is, regardless of how they were created. Other tools (such as DD Editor and ddcomp) will sometimes drop and re-create these indexes.
See Also |
Next |