Performance impact of Identity Columns

ED

Performance impact of Identity Columns
Hello everybody,

I need to read about the PERFORMANCE IMPACT of using IDENTITY COLUMNS.
Do you have experience or know any reference I can refer to?

Thanks...

Syed (TATA) Fazal

Re: Performance impact of Identity Columns
(in response to ED)
You can check the following link to check out about Identity column in
Chapter 3.1(DB2 UDB Server for OS/390 Version 6 Technical Update)

http://www.redbooks.ibm.com/pubs/pdfs/redbooks/sg246108.pdf
< http://www.redbooks.ibm.com/pubs/pdfs/redbooks/sg246108.pdf >

-----Original Message-----
From: [login to unmask email]
[mailto:[login to unmask email]
Sent: Tuesday, December 31, 2002 6:49 AM
To: [login to unmask email]
Subject: Performance impact of Identity Columns


Hello everybody,

I need to read about the PERFORMANCE IMPACT of using IDENTITY COLUMNS.
Do you have experience or know any reference I can refer to?

Thanks...


Francis C - CNF Leblanc

Re: Performance impact of Identity Columns
(in response to Syed (TATA) Fazal)
We're using identity columns in a number of high insert tables, and ran into
some contention on the SYSSEQUENCES table in the catalog. Once we increased
the number of cached values for each table, the contention disappeared.
Other than that, we've had no problems.



Good luck,



Fritz



-----Original Message-----
From: ED [mailto:[login to unmask email]
Sent: Tuesday, December 31, 2002 3:49 AM
To: [login to unmask email]
Subject: Performance impact of Identity Columns



Hello everybody,



I need to read about the PERFORMANCE IMPACT of using IDENTITY COLUMNS.

Do you have experience or know any reference I can refer to?



Thanks...