SDEView is slow...

GISAdmin_2008 — Thu, 18 Jul 2013 12:47:08 GMT

Hi,
I created an SDEView with a feature class and 2 tables. All of them reside on ArcSDE. When I created the view it took a long time to the view be created and draw in ArcCatalog.

The where clause look like this:
-w "f1.PIN=t1.PIN and( f1.parcareatp=t2.parcareatpcd and (t1.FunctionCD in (2108,2109,2151,2152,2153,2154,2161,2210,2211,2212,3110,3111,3112,3113,3114,3115,3130,3131,
3210,3215,3216,3221,3222,3311,3312,3321,3322,3323,3324,3325,3331,3332,3333,3334,3335,3340,
3341,3342,3350,3351,3352,3353,3360,3370,3400,3660,4000,4110,4111,4112,4113,4114,4115,4120,
4130,4133,4134,4135,4136,4137,4138,4140,4152,4170,4180,4214,4231,4232,4233,4234,4235,4236,
4237,4238,4240,4310,4312,4313,4314,4321,4331,4332,4333,4341,4342,4343,4344,4345,4346,5230,
6210,6221,6222,6300,6310,6320,6400,6410,6420,6430,6510,6511,6513,6514,6530,6531,6563,6564,
8000,8110,8120,8190,8191,8200,8300,8400,8500,9010,9020,9050,9130,9141,9230,9231,9312,9313,
9314,9320,9330,9340) or t1.PIN in(00582919,00336969,00261483,00261486,00261492,00261496,00261497,00261498,00261499,00261500,
00261501,00261502,00261503,00261505,00261506,00261508)) " ^

I was wondering if there is away that I can create this query and the view is created fast.

Re: SDEView is slow...

VinceAngelo — Thu, 18 Jul 2013 13:53:20 GMT

This is pretty much a worst case scenario for any SQL engine. If you're going to hard-code
a view like this, you're much better off just extracting the features into a new table and
regenerating the contents when the source changes.

- V

topic Re: SDEView is slow... in ArcGIS Enterprise Questions

SDEView is slow...

Re: SDEView is slow...