Is there a performance loss on a service containing a definition query?

[BrandonKeinath1]

It looks like I am able to publish services from data that contain definition queries.  Is there any performance loss doing it this way rather than a separate exported feature class?  You could also expand it to me wondering what the pros/cons are for publishing services with definition queries.

Thanks,

Brandon

[BrandonKeinath1]

Giving this a boost to see if anyone has any opinions.  I successfully published a service with a definition query but still looking to see what effects this might have long term

[XanderBakker · Accepted solution]

I guess it will be pretty fast if you set the right indexes, but publishing he data the corresponds to the query only, will probably be a little faster.

[BrandonKeinath1]

Hi Xander,

Which indexes should I be on the look out for?

Brandon

[XanderBakker]

The fields you are referencing in the query should have an attribute index to query data on attributes faster:

ArcGIS Help (10.2, 10.2.1, and 10.2.2)

[BrandonKeinath1]

Thanks Xander,

That's very helpful advice.  I will add that into our process documentation.

Best,

Brandon