AnsweredAssumed Answered

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

Question asked by mdunhamwilkie on Jul 21, 2014


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

Outcomes