33.4 SDO_TUNE.MIX_INFO
Format
SDO_TUNE.MIX_INFO( table_name IN VARCHAR2, column_name IN VARCHAR2 [, total_geom OUT INTEGER, point_geom OUT INTEGER, curve_geom OUT INTEGER, poly_geom OUT INTEGER, complex_geom OUT INTEGER] );
Description
Calculates geometry type information for a spatial layer, such as the percentage of each geometry type.
Parameters
- table_name
-
Spatial geometry table.
- column_name
-
Geometry object column for which the geometry type information is to be calculated.
- total_geom
-
Total number of geometry objects.
- point_geom
-
Number of point geometry objects.
- curve_geom
-
Number of curve string geometry objects.
- poly_geom
-
Number of polygon geometry objects.
- complex_geom
-
Number of complex geometry objects.
Usage Notes
This procedure calculates geometry type information for the table. It calculates the total number of geometries, as well as the number of point, curve string, polygon, and complex geometries.
Examples
The following example displays information about the mix of geometry objects in the SHAPE column of the COLA_MARKETS table.
CALL SDO_TUNE.MIX_INFO('COLA_MARKETS', 'SHAPE'); Total number of geometries: 4 Point geometries: 0 (0%) Curvestring geometries: 0 (0%) Polygon geometries: 4 (100%) Complex geometries: 0 (0%)
Parent topic: SDO_TUNE Package (Tuning)