How Teradata retrieves a row?
For example, a user runs a query looking for
information on Employee ID 100. The PE sees that the Primary Index Value EMP is
used in the SQL WHERE clause.
Because this is a Primary Index access operation,
the PE knows this is a one AMP operation. The PE hashes 100 and the Row Hash
points to a bucket in the Hash Map that represents AMP X. AMP X is sent a
message to get the Row Hash and make sure it’s EMP 100.
No comments:
Post a Comment