we are experiencing performance issues with our pinned filters.
when multple users are using them, the insert statement in SYS_QUERY_RESULT is reducing the performance extremely.
Is there a solution like using this table in memory - how can you help us?
The insert into database table is required to do the subsequent queries on the database, and I cannot imagine how to implement this feature without saving ids.
Maybe some tuning on the database level could help.