On Thu, Jun 21, 2012 at 9:31 PM, Ivan Suftin <isuf...@usgs.gov> wrote:
> Very basic question here, but I can't seem to find any documentation on it:
>
> When creating a store using Oracle JNDI, I have the option for "Estimated
> Extends". I can't seem to find any documentation on this option. Could
> someone explain what exactly this does and when I would want to have this
> on or off?
>
When the option is on the code will try to compute the extent using select
SDO_TUNE.EXTENT_OF('TABLE', 'GEOM) FROM DUAL,
which peeks the top of the spatial index instad of computing the actual
bounds.
When not enabled SDO_AGGR_MBR will be used instead, which results in a full
table scan instead (and provides an accurate result).
Extent computation is mostly used when configuring the layers (compute
native bbox link), but also by WPS processes like gs:Bounds
and by WFS when the "feature bouding" option is enabled.
Cheers
Andrea
--
Ing. Andrea Aime
GeoSolutions S.A.S.
Tech lead
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 962313
mob: +39 339 8844549
http://www.geo-solutions.it
http://geo-solutions.blogspot.com/
http://www.youtube.com/user/GeoSolutionsIT
http://www.linkedin.com/in/andreaaime
http://twitter.com/geowolf
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
