Jurgen, Thanks again.
How does one request this rownum<1000 number to be changed or implemented as a option? After all all the sdo_geometry types I deal with with customers are homogeneous based on polygon, line or point with multi... (Oracle users equate multipolygon with polygons and store them in the same singly inherited sdo_geometry column regardless as to what the OGC Geometry Type object diagram says about inheritance.) Additionally, why is it that even when the value is set in a layer's <datasource>'s type= attribute eg: <datasource>dbname='GISDB12' host=localhost port=1522 user='...' password='...' key='FID' estimatedmetadata=true srid=2872 *type=Polygon* table="QGIS"."FOO" (GEOM) sql=</datasource> QGIS still re-queries the database every time for the geometry type the project is loaded? SELECT DISTINCT gtype FROM (SELECT t."GEOMETRY".sdo_gtype AS gtype FROM "xxxx"."xxxx" t WHERE t."GEOMETRY" IS NOT NULL AND rownum<1000) WHERE rownum<=2 This re-query slows down project load times especially when one is using QGIS Server. It would be great if one could stop this re-query once the type is set when the original layer is set. After all nearly all layer data for most data sources are of fixed geometry type: Poly, line or point (+ multi). regards SImon -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Detecting-Geometry-Type-For-Oracle-Object-tp5305257p5305639.html Sent from the QGIS - User mailing list archive at Nabble.com. _______________________________________________ Qgis-user mailing list Qgisemail@example.com List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user