Skip to main content
10000+ Discussions
Difference between HASH.HELP.DETAIL and FILE.STAT results

When I run HASH.HELP.DETAIL APPOINTMENTS I get the following summary ---- >HASH.HELP.DETAIL APPOINTMENTS File APPOINTMENTS Ā Type= 5 Ā Modulo= 149 Ā Sep= 8 Ā  Ā  Ā 14:58:16 Ā 15-07-25 Ā PAGEĀ 1 Ā  Ā  Ā 138 Ā total keys in fileĀ  Ā  Ā 578 Ā total bytes in all keysĀ  Ā  Ā  Ā 3 Ā smallest keyĀ  Ā  Ā  10 Ā largest keyĀ  Ā  4.19 Ā average bytes per key Ā  Ā  Ā 138 Ā total records in fileĀ  696388 Ā total bytes in all recordsĀ  Ā  2492 Ā smallest recordĀ  Ā  6964 Ā largest recordĀ 5046.29 Ā average bytes per record Ā  Ā  Ā  Ā 0 Ā average records per group Ā (optimized)Ā  Ā  5009 Ā average bytes per group Ā (optimized) Press any key to continue... ---- When I run FILE.STAT APPOINTMENTS I get the following results: ---- >FILE.STAT APPOINTMENTSFile name Ā  Ā  Ā  Ā  Ā  Ā  Ā  Ā  Ā  Ā  Ā  Ā  Ā  Ā  Ā  = APPOINTMENTSFile type Ā  Ā  Ā  Ā  Ā  Ā  Ā  Ā  Ā  Ā  Ā  Ā  Ā  Ā  Ā  = 5File style and revision Ā  Ā  Ā  Ā  Ā  Ā  Ā  Ā  = 64BIT Revision 12NLS Character Set Mapping Ā  Ā  Ā  Ā  Ā  Ā  Ā  = NONENumber of groups in file (modulo) Ā  Ā  Ā  = 149Separation Ā  Ā  Ā  Ā  Ā  Ā  Ā  Ā  Ā  Ā  Ā  Ā  Ā  Ā  Ā = 8Number of r