How do I optimize a hand-made sequential key system for best performance?
– Question 8.1 of the comp.database.sybase FAQ has a quick blurb about identities and sequential numbers. Search down in the page for the section titled, “Generating Sequential Numbers.” Question 8.1 is a general document describing Performance and Tuning topics to be considered and thus doesn’t go into as much detail as this page. – There’s a white paper by Malcolm Colton available from the sybase web site. Goto the Sybase web site http://www.sybase.com and type Surrogate in the search form. Select the Surrogate Primary Keys, Concurrency, and the Cache Hit Ratio document. ——————————————————————————- Advantages/Features of Using Identities There’s an entire section devoted to Identity columns in the ASE Reference manual, Chapter 5 Sybase System 10 introduced many changes over the 4.9.x architecture. One of these changes was the Identity feature. The identity column is a special column type that gets automatically updated by the server
