Knowledge Base Article
KB10480 - How is it possible to improve the DK speed with SQL geodatabase vector layers?
Please ensure that that your database has 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 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 will significantly increase the speed.
Created: 2004-12-15, Modified: 2005-09-14
|