Index Maintenance dialog box

Use this dialog box to specify which types of indexes to create for the selected source drawings.

Indexes speed up queries, but they add to the size of your source drawings. If size is an issue, create indexes for just the types of queries you perform most often. For example, if you mostly perform queries based on location, create just a location index.

• To create an index, select the check box for the type of index you want. To create an object data index, click Object Data. At the Generate Object Data Index dialog box, select the tables and fields to index.

  To improve the performance of object data and SQL queries, create object data and SQL indexes for all drawings in the data set, even if they do not contain object data or SQL link information.

• To remove an existing index, select the check box for that type of index. To remove an object data index, click Object Data. At the Remove Object Data Index dialog box, select the tables and fields to remove from the index.

  Removing an index reduces the size of the drawing, and reduces the time it takes to save the drawing.

Because indexes are saved in the source drawing, you can create indexes only if the drawing is not in a read-only directory and you have Edit Drawing privileges. See User Administration dialog box.

Once you create an index, AutoCAD Map 3D toolset automatically updates the index each time you change the drawing and save the changes back. However, you will need to recreate the index in the following circumstances:

• If you notice that queries are taking longer. Over time, automatic updates can cause degeneration of an index. It is a good idea to periodically use this command to recreate the indexes.
• If you modify a drawing with AutoCAD or with AutoCAD Map 3D toolset when the drawing is not attached, you need to use this command to recreate the indexes.