What are Static Hash files and Dynamic Hash files?

As the names itself suggest what they mean. In general we use Type-30 dynamic Hash files. The Data file has a default size of 2Gb and the overflow file is used if the data exceeds the 2GB size.

Showing Answers 1 - 3 of 3 Answers


  • May 5th, 2006


The hashed files have the default size established by their modulus and separation when you create them, and this can be static or dynamic.

Overflow space is only used when data grows over the reserved size for someone of the groups (sectors) within the file. There are many groups as the specified by the modulus.

  Was this answer useful?  Yes


  • May 8th, 2007

Dynamic Hash Files can automatically adjust their sie - modulous (no. of groups) and separation (group size) based on the incoming data. Type 30 are dynamic.

Static files do not adjust their modulous automatically and are best when data is static.

Overflow groups are used when the data row size is equal to or greater than the specified Large Record size in dynamic HFs.
Since Static HFs do not create hashing groups automatically, when the group cannot accomodate a row it goes to overflow.

Overflows should be minized as much as possible to optimal performance.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Answer Question

Click here to Login / Register your free account

Send   Reset


Related Answered Questions


Related Open Questions