Select by Location in ArcMap 10.2.1 issues different SQL than in ArcMap 10.0?

MikeDunham-Wilkie — Mon, 21 Jul 2014 22:18:07 GMT

I have a large point layer and I'm doing a "Select by Location" to select all points that intersect a specific selected polygon from a polygon table.

In ArcMap 10.0 the SQL that was executed was basically the following:

1. Stick the se_rowid of the polygon into the sde_logfile_data table

2. Select all points that intersect the polygon

In ArcMap 10.2 the SQL is an alternating sequence of:

1. Insert the rowids of 10000 points into the sde_logfile_data table

2. Select count(distinct sde_row_id) from sde_log_table where logfile_data_id = ...

i.e., sde_logfile_data keeps getting inserted into and the subsequent selects take longer and longer. ArcMap ends up stalling and I have to kill it.

Does this sound familiar to anyone?

Many thanks

Mike

topic Select by Location in ArcMap 10.2.1 issues different SQL than in ArcMap 10.0? in Data Management Questions