Query assistance needed on view with large partitioned/sub-partitioned table

Hi Community members!

There is a requirement to pull some data from a database that we manage. The data is accounting related. I've been asked to provide some guidance on how to efficiently do this via SQL query. A view exists which contains the necessary data (group by's, summations, etc.) that the users need to have. This view contains a very large table in it of about 1.5 billion records and has several dozen columns. As I understand it, the table is partitioned on a column named "period" of VARCHAR2 data type (each 'period' represents 1 calendar month of data; i.e. JAN-2025, FEB-2025, …