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.
RE: What are Static Hash files and Dynamic Hash files?...
Hello
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.
RE: What are Static Hash files and Dynamic Hash files?...
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.
