we have been working on performance issues for some time now, and when we run a report in Crystal Reports XI (CR Developer, version 22.214.171.1249) and trace that session in Toad, we notice that Crystal is firing a lot of queries containing rule based optimizing hints. As known, Oracle 10G does not support rule based optimizing anymore.
So, we are wondering how to get rid of this setup as we expect to get a better performance without it.
Any help will be appreciated!!!
Thanks in advance!