544 views
0 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 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…

 

Position:
Show:

Related questions

1 1 vote
0 0 answers
158
158 views
Shubham Sharma 2 asked Apr 19
158 views
In relation to Index structures for files which of the following are true?An index is an integral part of the data file.An index can be created in conjunction with virtua...
8 8 votes
3 answers 3 answers
2.0k
2.0k views
Bikram asked Aug 26, 2017
2,005 views
Assume that a data file contains $2000$ records that are ordered by a key attribute $K$ , and a primary index on attribute $K$ is built.The size of key is $5B$ and block ...
0 0 votes
0 0 answers
479
479 views
gatecse asked Aug 4, 2019
479 views
A two level indexed sequential file of size $12,000$ records has $20$ entries in each index. The average number of accesses required for accessing a desired record is$600...
0 0 votes
0 0 answers
677
677 views
rishu_darkshadow asked Oct 5, 2017
677 views
For secondary key processing which of the following file organizations is preferred? Give a one line justification:Indexed sequential file organization.Two-way linked lis...