2 Replies Latest reply on Sep 23, 2015 5:21 PM by user9327139

    SQL Array Fetch Size and fast results

    user9327139

      If I set SQL Array Fetch Size to match the number of rows returned it return all 124 rows in less than a second. If I set the SQL Array Fetch Size to 1 more than the rows returned it takes 6 seconds to return the results.. I can run the same query directly on the DB server using SQL Plus and it too takes 6 seconds. Why does developer return my exact rows so fast