Filtering and Sorting Schema Browser Data

With cheap disk space, today’s databases are big. Likewise, many tables and views are also quite large. Thus great care should be taken when navigating the Schema Browser, for some of the left-hand-side (LHS) tabs (that is, tables, views, and snapshots) have a right-hand-side (RHS) tab for displaying the data as shown in Figure 2.19.

Figure 2.19. Viewing data.

And while these data grids fetch rows 25 at a time, there are user navigation scenarios that can cause problems (e.g. pressing last record button or scrolling the grid to its end). So if you select a million-row table on the LHS, choose its data ...

Get TOAD® Handbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.