When building views, there are performance considerations to make. Something as basic as creating a double sortable view can easily triple the view index's size. Across many databases, this type of space wasting can add up—bloating databases far beyond their actual size.
Traditionally, there hasn’t ever been a clear way to get view index information alongside other properties; either through the Admin client or server commands, you’ll have access to index size information, but at the expense of seeing any properties.
viewEZ lets you see the details of all view indexes across an entire database, all at once:
- Audit any number of view indexes within a database in just a couple of clicks. Your results will be displayed in a flexible grid layout where you can sort by key data points such as Index Size, Discard and Refresh settings, and more.
- Spot your most cumbersome View Indexes and purge them directly from the grid if needed whether you need to free up space or ensure proper performance.
- Understand your View Index discard and refresh settings globally, and adjust them for one or more views at once directly from the grid.
Quickly retrieve a clear overview of all View Index properties and settings in a database. Your fast track to understanding the impact of your View Indexes is viewEZ. Take a look!
Locate all inactive or unused views in a database—in only 2 steps!
Find views with discarded indexes quickly and easily, and comb through discard settings and index size information to spot views that are unused in a certain timeframe—all in ways not possible with the native tools.
Tip | Use databaseEZ to extend this functionality over multiple different databases.