is there a way (e.g. system view or command line tool) where I could check if an index is used at all?
I'm thinking about something like PostgreSQL's pg_statio_user_indexes or Oracle's v$object_usage.
I would like to run a typical workload in my application and after that check if indeed all indexes are used. Those that are not used for retrieval could potentially be dropped to increase insert/update performance.