You have to create a function based index over the function:

SDO_LRS.CLIP_GEOM_SEGMENT(SHAPE, 0, 10)

On the base table:

1. Create sdo geom metadata for the function:

Insert into user_sfo_geom_metada values( 'SDO_ROAD', 'SDO_LRS.CLIP_GEOM_SEGMENT(SHAPE, 0, 10)', SDI_dimarray....., SRID);

2. Create index:

Create index sdo_road_lrs_spx On sdo_roadS (SDO_LRS.CLIP_GEOM_SEGMENT(SHAPE, 0, 10)) Indextype is mdysy spatial_index Parameters('layer_gtype=MULTILINE');

You will need sdo Geo metadata for the view and the SHAPE_FIRST_10_METRES column.

You have to create a function based index over the function:

SDO_LRS.CLIP_GEOM_SEGMENT(SHAPE, 0, 10)

On the base table:

1. Create sdo geom metadata for the function:

Insert into user_sfo_geom_metada values(
'SDO_ROAD',
'SDO_LRS.CLIP_GEOM_SEGMENT(SHAPE, 0, 10)',
SDI_dimarray.....,
SRID);

2. Create index:

Create index sdo_road_lrs_spx 
On sdo_roadS
(SDO_LRS.CLIP_GEOM_SEGMENT(SHAPE, 0, 10))
Indextype is mdysy spatial_index
Parameters('layer_gtype=MULTILINE');

You will need sdo Geo metadata for the view and the SHAPE_FIRST_10_METRES column.

You have to create a function based index over the function:

SDO_LRS.CLIP_GEOM_SEGMENT(SHAPE, 0, 10)

On the base table:

1. Create sdo geom metadata for the function:

Insert into user_sfo_geom_metada values( 'SDO_ROAD', 'SDO_LRS.CLIP_GEOM_SEGMENT(SHAPE, 0, 10)', SDI_dimarray....., SRID);

2. Create index:

Create index sdo_road_lrs_spx On sdo_roadS (SDO_LRS.CLIP_GEOM_SEGMENT(SHAPE, 0, 10)) Indextype is mdysy spatial_index Parameters('layer_gtype=MULTILINE');

You will need sdo Geo metadata for the view and the SHAPE_FIRST_10_METRES column.

Simon

You have to create a function based index over the function:

SDO_LRS.CLIP_GEOM_SEGMENT(SHAPE, 0, 10)

On the base table:

1. Create sdo geom metadata for the function:

Insert into user_sfo_geom_metada values( 'SDO_ROAD', 'SDO_LRS.CLIP_GEOM_SEGMENT(SHAPE, 0, 10)', SDI_dimarray....., SRID);

2. Create index:

Create index sdo_road_lrs_spx On sdo_roadS (SDO_LRS.CLIP_GEOM_SEGMENT(SHAPE, 0, 10)) Indextype is mdysy spatial_index Parameters('layer_gtype=MULTILINE');

You will need sdo Geo metadata for the view and the SHAPE_FIRST_10_METRES column.