257 views
0 votes
0 votes
Hash indexing and Hash file organization are there in gate syllabus???

I also wanted to know what are the topics are there in file organization and indexes….as I don’t find much question from file organization in gate questions...then please provide the video link???

1 Answer

0 votes
0 votes

@samarpita

** Yes ..

 

## https://www.youtube.com/watch?v=zCa6DJTjkhg 

 

Hash indexing :

A hash index is an index type that is most commonly used in data management.

It is typically created on a column that contains unique values, such as a primary key or email address.

The main benefit of using hash indexes is their fast performance...

 

Hash File Organization :

Generally, hash function uses primary key to generate the hash index – address of the data block.

Hash function can be simple mathematical function to any complex mathematical function.

Hash Index-The prefix of an entire hash value is taken as a hash index…

 

Related questions

0 votes
0 votes
0 answers
3