Yes, you need to create materialized view for index or you can use KingFdoClass metadata table to tell provider which column will be used as primary key.
Haris -----Original Message----- From: mapguide-users-boun...@lists.osgeo.org [mailto:mapguide-users-boun...@lists.osgeo.org] On Behalf Of GordonL Sent: Wednesday, May 20, 2009 3:05 PM To: mapguide-users@lists.osgeo.org Subject: Re: [mapguide-users] Oracle FDO and View Thanks David, Index on a view? The core tables are already indexed - including the GEOMETRY column. Do you mean convert it to a MATERIALIZED VIEW and index it then? thanks gordon David Hequet wrote: > > Hi, > > Features can be selectable if you add primary key to your view (MapGuide > need Primary key on all feature to be selectable). > > David > > > GordonL wrote: >> >> Hi David, did you ever solve this problem? >> >> I am having trouble that features drawn from VIEWS in Oracle are not >> selectable (FDO 4.3). This is true for both the Autodesk Oracle Provider >> AND the KING one.. >> >> thanks >> gordon >> >> >> David Hequet wrote: >>> >>> Hello, >>> >>> About this case i'm using Autodesk Mapguide Enterprise 2008 with >>> Autodesk Spatial Oracle FDO. >>> One of the new feature is "using Oracle View" >>> I tried to use a view with geometry, it work, but features can't be >>> selectable! I make them selectable in Studio but they are not, either in >>> dwf or ajax viewer. >>> >>> Is it the same with the Oracle King provider? Or anyone has an idea on >>> how make them selectable (really :p ) >>> >> >> > > -- View this message in context: http://n2.nabble.com/Oracle-FDO-and-View-tp1811392p2946000.html Sent from the MapGuide Users mailing list archive at Nabble.com. _______________________________________________ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users _______________________________________________ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
