Chapter 3 Building Physical Diagrams


Updating Column Statistics

You can enter values in the Null Values, Distinct Values and Average Length fields. Alternatively, you can automatically populate them during reverse engineering by selecting the Statistics check box in the Reverse Engineering dialog box (see "Reverse Engineering from a Live Database" 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) 2007. Sybase Inc. All rights reserved.