Feature request #9591
Oracle connection to use metadata table for extent
|Pull Request or Patch supplied:||No||Resolution:||duplicate|
|Easy fix?:||No||Copied to github as #:||18171|
Currently when adding an Oracle layer QGIS performs a MBR check against the layer (SDO_TUNE.EXTENTS_OF). This hangs QGIS for several minutes if the table is a large one (millions of rows) and/or/especially if there are multiple tables.
An approximate MBR is already held in the MDSYS.USER_SDO_GEOM_METADATA - this should be used instead.
I'd suggest assigning it to "use estimated table metadata" checkboxes so people who want the exact boundaries (i.e. those who don't keep their GEOM up to date) can use those instead.