Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Fetching takes a lot of time

sql_coderMar 24 2026

Hello,

I have a very simple query (Oracle 19c) from one table with about 25.000 records in the result set. It takes about 10 seconds to fetch all rows to my SQL client. Is there any way to speed it up (besides network performance) ?

SELECT ID from Table_Name;
Comments
Post Details
Added on Mar 24 2026
3 comments
84 views