Chapter 3 Building Physical Diagrams


Updating Column Statistics

You can enter values in the Null Values, Distinct Values and Average Length fields or automatically populate them during reverse engineering if you select the Statistics check box in the ODBC Reverse Engineering dialog box (see "Reverse Engineering from an ODBC Data Source" in the "Reverse Engineering a Database into a PDM" chapter).

You can refresh the value of these fields (along with those for all of the table's columns) at any time by right-clicking the table symbol or its entry in the Browser and selecting Update Statistics from the contextual menu. You can also update the statistics for all tables by selecting Tools→Update Statistics (see "Reverse Engineering Database Statistics" in the "Reverse Engineering a Database into a PDM" chapter).

 


Copyright (C) 2006. Sybase Inc. All rights reserved.