Problems solve by adding index to all Asset_ID and Asset_Class_ID!!! That's awesome!
Thank you TabrizSoftware! -- 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-tp5304096p5304551.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