With almost 200 million documents in our repository since 2016, and growing each day, I am encountering performance difficulties on custom SQL queries used to create data providers in Dashboards.
I'm working with an Oracle DBA at my org, who is not well versed in OnBase, and he is looking at some of my queries to determine if additional indexes might help, etc. I'm an avid SQL query writer, and just venturing into more database level performance tools and approaches. I just write my query and it works... but takes a long time. Most of my queries are time limited, often to a 13 month lookback. 🙂
I was wondering if it's normal or helpful to create a view for each document type group (which corresponds for us to a business unit implementation), and create a view for the "average document." Basically the big join of all keywords on those documents?
What other good tools, tips or tricks are out there in the real world. I have read at length both the Database Reporting Guide and the Database Reference guide for our version, 22.1.
