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

Bud — Wed, 28 Dec 2022 13:26:13 GMT

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.

idea Don't SELECT * when fields are disabled in layer properties in ArcGIS Pro Ideas

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