How do I retrieve only certain number of rows at once in the Data Grid and have Toad retrieve more when I scroll down for more data.
1. Please go to the Tools | Option | Database | General.
2. Under "Numbers of rows to initially fetch in data tab", type in the number you want to fetch. If the "Unlimited" is checked, it will retrieve all data. If not checked, it will fetch the number specified in that box first.
3. Check "Apply to Editor" if you also want this behavior to work this way in the Editor as well.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center