[mapguide-users] Oracle FDO and View

[David Hequet]

With Oracle you can add primary key (don't confuse index and Key) to view
(sorry i don't have the sql here).

Materialized view is a good way to improve performance (espacially if you
use view on multiple database).


Haris Kurtagic wrote:
> 
> 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-bounces at lists.osgeo.org
> [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of GordonL
> Sent: Wednesday, May 20, 2009 3:05 PM
> To: mapguide-users at 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 at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> 
> 

-- 
View this message in context: http://n2.nabble.com/Oracle-FDO-and-View-tp1811392p2946099.html
Sent from the MapGuide Users mailing list archive at Nabble.com.