Create nonspatial index in SDF via FDO?

Jason Birch Jason.Birch at nanaimo.ca
Mon Sep 11 22:17:42 EDT 2006


Hi all,
 
Is it possible to create a non-spatial (attribute) index in the SDF format using FDO?  I'm seeing really poor performance on queries with attribute filters applied on a fairly small (14000 row) table and I'd like to try applying an index to see if it makes a difference.
 
I know that SQLite supports attribute indexes
http://www.sqlite.org/lang_createindex.html
but can't find a method in FDO to create them, and the SQLite tools don't seem to like opening up SDF3 files directly.  Any ideas?
 
Thanks,
Jason




More information about the Fdo-internals mailing list