Don't SELECT * when fields are disabled in layer properties

325
0
12-22-2022 07:46 AM
Status: Open
Labels (1)
Bud
by
Notable Contributor

It's my understanding that ArcGIS Pro does a SELECT * even when the user has disabled some fields in the layer properties.

I think Pro should only select specific columns — the columns that are enabled — rather than selecting all columns.

select
objectid,
asset_id,
type,
shape
--exclude disabled columns
from
sidewalks

Selecting only the columns we actually need would improve performance and reduce the load on the system.

I'm aware that we can force ArcGIS Pro to only select the columns we need by creating a view or query layer for certain kinds of geodatabases. But that has shortcomings: it adds extra complexity to our maps or databases and doesn't help us if we want to edit the data, since views and query layers can't be edited.

I think it would be better if Pro only selected the columns we need, by default, when unwanted fields are disabled in the layer properties.