DSXchange

Why hash file is used as the intermediate file?

Please avoid posting interview questions.

Have you attempted using them or tried searching this forum ?

femil wrote:Why hash file is used as the intermediate file?

Thanks for the advice, it's not an interview question.

i want to know that why hash file is prefered for intermediate file rather than sequential file

femil wrote:

femil wrote:Why hash file is used as the intermediate file?

Thanks for the advice, it's not an interview question.

i want to know that why hash file is prefered for intermediate file rather than sequential file

Who said that hash file is preferred to use as intermediate file rather than sequntial file in Server Edition ???
Kindly clarify ?

If the intermediate file is to be read sequentially, then using a hashed file instead of a sequential file would be adding unnecessary overhead.

Please advise the source of this advice (that hashed files should be used as intermediate storage) and the context in which it was given. I predict that you have taken the advice out of a quite specific context.