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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.