Can anyone help cause we are experiencing performance issues in one environment as compared to another one. Note that both environment have the same RPD. The environment in which we have the performance issue generates SQL "WITH OBICOMMON0 AS....." as compared to the other environment where the reports works fine generates SQL "WITH SAWITH0 AS ...".
Thanks and Regards
Please compare the sql plans of both the queries .