10.1 sde sql server geometry type
I have a feature class that has a spatial index. I create an sde view on that fc using sde command line.
i then modify that sql to join in a few business tables.
sde view displays fine in catalog and in arcmap.
I go to create an ags map service on the mxd with the view in it and i get a warning that there is no spatial index on the sde view.
sde describe_long on the base table shows spatial index present
sde describe_long on the sde view shows spatial index present
what is going on?
I have updated dbms stats. no luck.