UMN-Mapserver Oracle Spatial 10g - Performance

[Gregor Fikoczek]

Dear All,

I got a Oracle Spatial 10g Database connected to the UMN-Mapserver 
(Mapbender),
but the presentation/performance of the oracle-data is very poor : 10 
sec. or more.

#### mapfile ###

CONNECTIONTYPE oraclespatial
CONNECTION "xxxxxx/xxxxxxx"

DATA "GEOM FROM (SELECT PROV3NAME, EINWOHNER, GEOM FROM kreise_oracle)"

####

I also created a Spatial Index:

CREATE INDEX IDX_KREISE_ORACLE ON KREISE_ORACLE(GEOM)
INDEXTYPE IS MDSYS.SPATIAL_INDEX;

[The table got 418 rows]

What can I do to speed up the performance ?