No spatial index on sde view

Discussion created by KG22 on Feb 8, 2013
Latest reply on Feb 25, 2013 by VBAHole
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.