Online Documentation for SQL Manager for Oracle

Last Analyze Stats

The Last Analyze Stats tab displays the objects (tables and indexes) and the date when these objects were last analyzed (i.e. when statistics was last gathered).


Hint: Statistics for tables/indexes can be gathered with the help of Advanced Statistics Wizard.


Database Statistics - Last Analyze Stats


The list displays the objects as a grid with the following columns: Owner, Name, Last Analyzed. If more convenient, you can change the order of the columns by dragging their headers horizontally.


If necessary, you can group the data in grid by any of the columns. This operation is performed by dragging the column header to the gray "Group by" box area at the top. When grouping by a column is applied to the grid, all the rows are displayed as subnodes to the grouping row value. To reverse grouping, just drag the column header back.


Click a column caption to sort items by values of this column in the ascending or the descending mode.


In order to filter items in grid, you can use Custom Filter and Filter Builder dialog. For more information refer to the Filtering records page.