[Qgis-user] QGIS with ORACLE view bad performance

[Astrid Emde]

Hello,

we could get great performance with materialized views with spatial
index instead of normal views.

Best regards

Astrid

Am 05.08.2014 10:55, schrieb Astrid Emde:
> Hello,
>
> I have a project with ORACLE data in QGIS 2.4.
>
> When I load the geometries from a table which has a spatial index, the
> data display is fast and query information is displayed at once.
>
> When I create a view (add an entry to SDO_GEOM_METADATA) and add the
> view to QGIS it is very slow and query information is slow too.
>
> It looks like the spatial index from the table is not used.
>
> Do you have an idea what I can do to get better performance?
>
> Thanks for your helf.
>
> Best regards Astrid
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user