O'Reilly logo

Tera-Tom's 1000 Page e-Book on Teradata Architecture and SQL, 2nd Edition by Tom Coffing, William Coffing

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 4 – Hashing of the Primary Index

“Write a wise saying and your name will live forever.”

- Anonymous

The Hashing Formula Facts

images

images  There is only one Hashing Formula.

images  A row's Primary Index value is hashed, and the output is its Row Hash.

images  The Row Hash will be stored with the row (on disk) as part of the Row_ID.

  If the Hashing Formula hashes ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required