I am working with a customer that has Oracle 11g as the DBMS. In the test environment we have noted that when running a field search for a single value with no wildcards the performance difference between 8.2 and 9.2.1 is dramatically slower. In 8.2 we are seeing a 1 second search time to return the results, whereas in 9.2.1 we are seeing 15 seconds or more to return the same results.
The customer's Oracle DBA is analyzing the query that is running, but I thought I may get an answer here. Any ideas why this dramatic difference in search times?
Thanks,
Bryce