Use this dialog box to
specify which types of indexes to create for the selected source
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
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 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
- 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
- If you modify a drawing with AutoCAD
or with AutoCAD Map 3D when the drawing is not attached, you need to
use this command to recreate the indexes.
check if a source drawing has an index created, select the drawing
in the Drawing Maintenance dialog
box. Click Drawing Index to display the Index
Maintenance dialog box. If the source drawing contains
a usable index, the check box for that index is not selected. If
the drawing does not contain an index, or if the index is out of
date, the check box for the index is selected.