Knowledge Base

KB10480 - Improving the DK speed with SQL geodatabase vector layers.

The database should have separate indexes for the UID, XMIN, XMAX, YMIN and YMAX fields. Such separate indexes are added automatically to SQL vector layers created with the DK v.8 and subsequent DK versions, but prior DK versions (including the DK 8 RC 1) created only a compound index. Having separate indexes for each field significantly increases the speed.

Created: December 15, 2004, Modified: July 30, 2015