I'm struggling to understand at this point the correct method for creating spatial views at 10.1. I have tried using the new view option when you right click a database connection and specify a query; When I do this, it creates a query table instead of a spatial view despite specifying the ObjectID and shape field in the view query. ArcMap can't seem to determine the ObjectID field when I try to add it to the map either, so I get a dialog box asking to select a unique identifier field every time I add it to the map.
What is the correct way to create a spatial view at 10.1? Should I just continue to use the sde command on my database server to do this?