File>Database>Information

joe361

In Navision 3.01, native database version, if you go to File>Database>Information and click the Tables button there’s a column labeled Optimization. I was wondering what the numbers mean, is a low number better than a high number, what’s the range, etc.

Title changed from "Tables Question" to "File>Database>Information" because it is a better title for Navision Tips&Tricks

kriki

-"No of Records": this is the number of records in the DB.
-"Record Size": this is the size of 1 record (data + indexes)
-"Size (KB): this is the total size the table uses (data + indexes)
-Optimization : the higher the number, the more optimized the table is. This can be both good and bad.
-If you have a table that you READ a lot and WRITE almost never (e.g. T15:"G/L Account") it is better optimized because an optimized table can be read faster. So this is a table you can optimize.
-If you have a table that you WRITE a lot (independant of reading) (e.g. T17:"G/L Entry", T37:"Sales Line"), is is better NOT to optimize it, because optimizing speeds up for reading but slows down for writing. In general a table that is not optimized is between 50% and 60%.

This was for a Navision DB. I suppose you have a Navision DB.

Waldo

May be you can put this on tips&tricks? Don't think many people know this.
=D>

ara3n

-"Record Size": this is the size of 1 record (data + indexes)
-"Size (KB): this is the total size the table uses (data + indexes)

I believe it's (data + indexes+sift tables + sift indexes)

kriki

ara3n wrote:

-"Record Size": this is the size of 1 record (data + indexes)
-"Size (KB): this is the total size the table uses (data + indexes)

I believe it's (data + indexes+sift tables + sift indexes)

True. But SIFT-tables are partly data and partly indexes.

DenSter

Part of the table size though, although I don't know for sure if that is the case on SQL Server, since those are separate physical tables.

kriki

[Topic moved from Navision Attain forum to Navision Tips & Tricks forum]

Title changed from "Tables Question" to "File>Database>Information" because it is a better title for Navision Tips&Tricks