Return
-
Title
Is creating a NonClustered Index suppoeted for the Intrust databases -
Description
An administrator imports data from the repository into a new independent database and executes a custom query against it. He observer that the query is slow to to execute and his DBA recommends creating a Non-Clustered Index. He needs to know if this is supported.
-
Resolution
Although the DBA (Execution Plan) indicated that the Index will improve performance, modifying the schema of the database is not supported, so we recommend backing up before proceeding.