When running a "Select * from table_name" or just going to the data tab in the Object Explorer, the default for Toad is to initially fetch 1000 rows. Then when you scroll to the bottom of the list, Toad asks if you want to fetch ALL data. If the table is large, this action would take a long time to return all the rows.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center