Performance with joins

[Knight, Gregory]

I have some general questions regarding best practice / performance when
doing feature joins.  

 

Is there a guideline or preference towards using SHPs vs. SDFs when
doing feature joins? 

 

If I have indexes in my SHP on the columns that I will join on, will MG
respect these when/if I convert them to SDF?  

 

Is there a guideline or preference towards joining with an external ODBC
source vs. an internal MG feature source?


Is there a guideline or preference towards joining internally managed or
external resources?

 

Specific recommendations and/or general experience in this area is
appreciated.

 

Many thanks,

 

Greg Knight




-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally
privileged and/or exempt from disclosure pursuant to Massachusetts
law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and
delete the material from any computer.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide_users/attachments/20061023/e7266779/attachment.html