The main problem which made me think of detaching from views is that update cannot be done (getting database exception : modification affects multiple base tables)