I am running into issue with performance on our query runs. I have tried creating aggregates..however based on how our queries are written(we are bringing back a whole bunch of data involving navigational attributes), I cannot get any of the queries to hit the aggregates. The only time I have had any kind of success is when I have my aggregates defined explicitly to include all the characteristics that are included in the query. We are dealing with about 5 million records in 0bpartner(the queries are brining back several navigational attributes for 0bpartner in addition to some other characteristics) and also have hierarchy based reporting....other than with using aggregates, what other ways can I try and speed up query performance...any tips or tricks that you folks can provide is much appreciated. Thanks
Dinesh
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.