This example collects statistics on the geospatial index defined on geospatial column sp.
You define the following table.
CREATE TABLE stat_t2_idx ( rownum INTEGER, a INTEGER, b INTEGER, c INTEGER, d INTEGER, e INTEGER, sp ST_GEOMETRY, dummy CHARACTER(20000)) INDEX (sp);
You can then collect statistics on the geospatial index sp, using a request like the following.
COLLECT STATISTICS INDEX(sp) ON stat_t2_idx;