Assume that you have layers that contain the roads for all the New England states. The layers are stored in a tables called ME, VT, NH, MA, RI, and CT, in a column called GEOMETRY. The extents of these layers are -90 to 90 and -180 to 180 (in the USER_SDO_GEOM_METADATA view), and all of these layers are indexed.
You start the Spatial Index Advisor. In the Add Layer dialog box, you select the layer NH(GEOMETRY). The alias is set to NH and the color is set to black. After you click OK, the application does the following:
You decide to examine the geometries in detail, so you click the Zoom to Reasonable Size toolbar button (or select View > Zoom to > Reasonable Size). You move the pointer to the center of the desired area and click.
You view the information and recommendations in the Tips area, display fixed-size and variable-size tiles, and query some desired geometries (Layer > Query > ...). Based on the information displayed, you decide whether or not to modify the index, and eventually you have the desired index values for NH.
Now that you have a good tiling level for NH, you modify the index for MA to have the same level and number of tiles, and then analyze this index. If it appears acceptable, you change the indexes for the rest of the states and analyze each index to see if it is acceptable.
See also: Usage scenarios, Main help topics (outline)