I would assume that in a lot of cases, users will target at least two DBs (production and a in-memory one). So keeping indices and primary key information for the in-memory one is generally a good idea IMO.