0 - 4 of 4 tags for hash index



There may be a discussion already in this forum about Hash and Join Index.

Still I am creating this post because I want to clarify few queries for my own understanding.


I am creating a HASH INDEX: here the PI of the table is (emp_id)



Really wonder how these indexes are different, which one to use and where to use. Any help would be greatly appreciated.


Why cannot a table's primary index be partitioned, if a hash index is defined
on the table?