I was wondering what would be the best way to create ARRAY inside an ARRAY, especially when you have huge data source(8M records)? I achived it using derived views but because of the data, when I create the 2nd ARRAY with ARRAY( from the derived view) inside it, it runs for a very long time, which offsets its functionality.
So, can you please suggest a better way? Thank you in advance.
Thanks & Regards,