Which query is better inner join or in???

[mike9]

When I run the queries in SQL Plus they run fine, but when they run through the Java app they are painfully slow. I included a sql trace to show the difference. The performance of the app can vary greatly depending on how stale the stats are.

When you execute it via the application is it the sql query which is slow or the response time from the application. Did you trace a query executed by the application?