Indexes

[Liam1]

Hello,

I have been looking through some NCR's docs and noticed you can create a Hash Index.

1. What distinguishes this from a 2ndary index?
2. Is this more benificial than a "normal" 2ndary index?

Thanks,

Liam1

 

[dnoeth]

1. A Hash Index is a special kind of Join Index with some restrictions. It's similar to a NUSI but you can specify it's internal storage/distribution.

2. It depends ;-)

So why don't you read the manuals for more info?
Database Design: Chapter 11
SQL Vol 4: Chapter 1

Dieter