0 - 4 of 4 tags for hash index

Hi

 

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)

 

Hi,

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

Thanks.

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