We use Oracle db. Some indexes were created from the jShell. While mos of the indexes seem to be active, for some it seems to be inactive.
When we send a query from jBase with a "WITH" clause on the indexed key, for some the SQL query to Oracle is translated with a "WHERE" clause and the performance is fine. But for a few, though there is an index available for that key, the translated SQL query does not have the "WHERE" clause. Hence the Oracle db returns the entire cursor and the filtering happens at jBase end. What could be the reason for this behaviour? --~--~---------~--~----~------------~-------~--~----~ Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en -~----------~----~----~----~------~----~------~--~---
