2011

Click Map Setup tab ➤ Map panel ➤ ➤ Drawing Maintenance.
NOTE This option is for drawing object data only. For information about filtering
geospatial feature data, see
Filtering Feature Layers (page 1216).
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
(page 1931) 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
(page 1933) 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 (page 1934).
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 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 when
the drawing is not attached, you need to use this command to recreate the
indexes.
1932 | Chapter 37 Setting Map Options Dialog Boxes