摘自oracle帮助文档: Oracle provides extensible indexing to accommodate indexes on customized complex data types such as documents, spatial data, images, and video clips and to make use of specialized indexing techniques. With extensible indexing, you can encapsulate application-specific index management routines as an indextype schema object and define a domain index (an application-specific index) on table columns or attributes of an object type. Extensible indexing also provides efficient processing of application-specific operators.
/* 4.0 Domain Indexes on Embedded Object Types ============================================ Oracle9i extends domain indexes so they can be created on an object embedded within another object. Even though there is no syntax change, the users get the added capability to build domain indexes on embedded object types. They can also take an object type with a domain index built on it and seamlessly make it a part of another object. Existing domain indexes on the embedded object will continue to work. Example 3 --------- */ SQL> CREATE TYPE super_spatial AS OBJECT ( attr NUMBER, data mdsys.sdo_geometry ); / Type created. SQL> CREATE TABLE super_ets ( c1 NUMBER, c2 super_spatial ); Table created. SQL> INSERT INTO user_sdo_geom_metadata VALUES ( 'SUPER_MARKETS', 'C2.DATA', mdsys.sdo_dim_array ( mdsys.sdo_dim_element ('Long', -180, 180, 0.005), mdsys.sdo_dim_element ('Lat', -90, 90, 0.005)), 8307); 1 row created. SQL> CREATE INDEX idx ON super_ets(c2.data) INDEXTYPE IS mdsys.spatial_index; Index created.-----------借你帖子收藏下。。呵呵
http://blog.csdn.net/bluestream/archive/2008/09/28/2990631.aspx
Oracle provides extensible indexing to accommodate indexes on customized complex data types such as documents, spatial data, images, and video clips and to make use of specialized indexing techniques. With extensible indexing, you can encapsulate application-specific index management routines as an indextype schema object and define a domain index (an application-specific index) on table columns or attributes of an object type. Extensible indexing also provides efficient processing of application-specific operators.
/*
4.0 Domain Indexes on Embedded Object Types
============================================ Oracle9i extends domain indexes so they can be created on an object embedded
within another object. Even though there is no syntax change, the users get
the added capability to build domain indexes on embedded object types. They
can also take an object type with a domain index built on it and seamlessly
make it a part of another object. Existing domain indexes on the embedded
object will continue to work.
Example 3
---------
*/
SQL> CREATE TYPE super_spatial AS OBJECT (
attr NUMBER,
data mdsys.sdo_geometry );
/ Type created. SQL> CREATE TABLE super_ets (
c1 NUMBER,
c2 super_spatial ); Table created. SQL> INSERT INTO user_sdo_geom_metadata VALUES (
'SUPER_MARKETS',
'C2.DATA',
mdsys.sdo_dim_array (
mdsys.sdo_dim_element ('Long', -180, 180, 0.005),
mdsys.sdo_dim_element ('Lat', -90, 90, 0.005)), 8307); 1 row created. SQL> CREATE INDEX idx ON super_ets(c2.data)
INDEXTYPE IS mdsys.spatial_index; Index created.-----------借你帖子收藏下。。呵呵
http://download.oracle.com/docs/cd/B10501_01/appdev.920/a96595/dci07idx.htm
http://download.oracle.com/docs/cd/B10501_01/appdev.920/a96595/dci07idx.htm