0 - 4 of 4 tags for hash index
Help with avoiding redistribution using a hash index

Hi,

 

By ps.suma@gmail.com, 01 Dec 2014 | Tagged: ordered analytic function hash index redistribution | 4 comments
Hash Index and Single Table Join 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)

 

By Santanu84, 05 Oct 2013 | Tagged: database join index hash index index | 6 comments
Difference between Single Table Join Index, NUSI and Hash Index

Hi,

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

Thanks.

By jainayush007, 30 Jul 2011 | Tagged: nusi hash index single table join index | 7 comments
Hash Index and PPI

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

By Kishore_1, 24 Feb 2011 | Tagged: partitioning hash index | 1 comment