N
nilesh pharate
Guest
I am using progress data server for oracle. Actual DB resides on ORACLE 11g and only progress schema is created with oracle DB schema and used to connect Oracle DB using ora-brokers. We want Oracle to handle index selection as per execution plan, so we added -noindexhint parameter for Data Server and it stopped index hints from queries which are hitting to Oracle. Now issue is even if there is no index hint, Data server is adding order by clause to SQL query using indexes matching where clause columns and their sequence.(even if by clause in not used in progress query). Because of this order by coming from Data server, Oracle is forced to use different index which is taking much time. One solution here seems removing all indexes from Schema holder as in source code we are not using any explicit use-index keyword. Kindly provide your comments for handling this case.
Continue reading...
Continue reading...