Hi, Are you using index on "Asset_Class_ID" and "Disposal_Date" fields ?
please index all Asset_ID and and Asset_Class_ID in all tables -- View this message in context: http://osgeo-org.1560.x6.nabble.com/SQL-Server-Inner-Joint-Table-Slow-To-Display-Selection-Info-On-AIMS-2014-tp5304096p5304413.html Sent from the MapGuide Users mailing list archive at Nabble.com. _______________________________________________ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users