I need to compare millions of geometries by the && operator (BBOX).
When CREATE TABLE see geometry type on PostGIS2, it do also something like INDEX ON t USING GIST(g)? or I need to express, always, the CREATE INDEX in (or after) my CREATE TABLE?
If it is automatic, it is for any field name (or only for "geom")?
PS: (if no index is automatically crated) when I use ST_DWithin(A,B) PostGIS generate a temporary index?
No comments:
Post a Comment