Adding an Index to a Managed Table

Ayvi Islam

Indexes are used in queries to retrieve data faster within a large managed table.

In SolveXia's managed table designing environment, indexes can be created for a table by selecting the "+ Add index" button :

Select the columns used for indexing and then press "Apply".

Note that columns used as primary keys, indexes and uniqueness constraints can't be deleted.

*Please read Microsoft's article, "SQL Server Index Design Guide", for tips regarding designing proper indexes.

0 comments

Please sign in to leave a comment.