[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
RE: [udig-devel] Odd Oracle behavior
|
The metadata for the table looks something like:
SELECT * FROM TABLE(SELECT diminfo from usgm where
table_name='myCountyLayer');
SDO_DIMNAME SDO_LB SDO_UB SDO_TOLERANCE
X -180 -60 0.00000002
Y 10 130 0.00000002
The other interesting thing here is that it is scanning a table we never
actually selected. Is it possible to switch to only examining tables
once we have checked them?
AP
-----Original Message-----
From: udig-devel-bounces@xxxxxxxxxxxxxxxxxxxxx
[mailto:udig-devel-bounces@xxxxxxxxxxxxxxxxxxxxx] On Behalf Of Jody
Garnett
Sent: Thursday, August 16, 2007 12:19 AM
To: User-friendly Desktop Internet GIS
Subject: Re: [udig-devel] Odd Oracle behavior
As usually being able to help test works wonders, can you confirm that
the table in question has the the SDO metadata filled out? That is our
only chance to avoid the full table scan (since we need to know the
extent of the data).
Cheers,
Jody
Parks, Aaron B. wrote:
>
> I am using RC10A and the ojdbc14.jar and am able to login and get a
> list of available schema from my Oracle server. However the oracle
> connection is doing a full table scan on every table in the DB, even
> for layers I don't select. Needless to say I haven't waited to see if
> it actually displays something once it finishes.
>
> Is this the expected behavior or am I missing something important?
>
> AP
>
>
------------------------------------------------------------------------
>
> _______________________________________________
> User-friendly Desktop Internet GIS (uDig)
> http://udig.refractions.net
> http://lists.refractions.net/mailman/listinfo/udig-devel
>
_______________________________________________
User-friendly Desktop Internet GIS (uDig)
http://udig.refractions.net
http://lists.refractions.net/mailman/listinfo/udig-devel