Series: Subject: Topic:
Question: 600 of 645

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.
Asked by: Interview Candidate | Asked on: May 24th, 2005
Showing Answers 1 - 3 of 3 Answers

Answered On : May 5th, 2006

View all answers by Alfons

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.

Login to rate this answer.

Answered On : May 8th, 2007

View all answers by gagan8877

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.

Login to rate this answer.

Answered On : Jun 12th, 2007

View all answers by klsrao

Good explanation.

Login to rate this answer.

Give your answer:

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

Related Open Questions



twitter fb Linkedin GPlus RSS


Interview Question

 Ask Interview Question?


Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.