Select to view content in your preferred language

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

1863
0
07-21-2014 03:18 PM
MikeDunham-Wilkie
Deactivated User


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

0 Kudos
0 Replies