|
<<SNIP>>
what would all of the overhead of an IDcol achieve that a RRN() could not, for the same scenario?
How much overhead is there in a surrogate key? Plus, it doesn't
change w/reorgs or reloads. However, for the sole purpose of paging
I think you could use RRN just as well as a ID column.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact copyright@midrange.com.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.