Hash Function

**ligang** · 10-29-2002, 09:07 PM

I have a table which PK consists of 17 cols .
To reduce the possibility of DML performance problem , I want to find a way to reduce the number of PK cols . The best way I think is to make a new representive PK col which can be calculated from others.

Could anyone provide some thoughts ?

**marist89** · 10-29-2002, 10:27 PM

How can you agree with ChrisRLong in http://www.dbasupport.com/forums/sho...threadid=30820 yet have no idea in this thread?

**ligang** · 10-29-2002, 11:12 PM

Please tell me your thoughts

**marist89** · 10-29-2002, 11:26 PM

Just use a surrogate key and populate it with a sequence...

**ligang** · 10-30-2002, 01:12 AM

This way (trigger + sequence) is ok in normal case , but the problem is how to link back the sequence with the individual PK col .

**chrisrlong** · 10-30-2002, 11:14 AM

Originally posted by ligang
This way (trigger + sequence) is ok in normal case , but the problem is how to link back the sequence with the individual PK col .

What????????????????

And how is this different than the previous thread? As in, why would you possibly start another thread with the exact same question?

- Chris

Thread: Hash Function

Thread Tools

Display

Hash Function

Posting Permissions