We are using PowerBuilder 9 with Sybase and Oracle as back ends. One of the queries is taking too long. It uses the "in" clause for an array argument and I see that the index I want to use is not being used.
Of course when I change the query to read "where emp_id = :ll_emp_id" instead of "where emp_id in ll_emp_ids)" then it uses the emp_id index and performance is great.
Anyway to force it to use the emp_id index when I need to query on multiple emp_ids?
Of course when I change the query to read "where emp_id = :ll_emp_id" instead of "where emp_id in ll_emp_ids)" then it uses the emp_id index and performance is great.
Anyway to force it to use the emp_id index when I need to query on multiple emp_ids?