Eric,

1. Does SQLServer have any counterpart for the ROWID column of Informix,Oracle and Sybase? 2. We use clustered indexes for static reference tables in both OLTP and DSS/DW systems. Are clustered indexes efficient for volatile tables - like transaction tables for bank ATM's or telecomms applications ... why or why not?

Thanks, Chelo

-- Anonymous, February 24, 2000

Answers

Chelo,

1. No.

2. Clustered indexes are not efficient for volatile tables. The SQL Server Books Online article, "Using Clustered Indexes", states: "Clustered indexes are not a good choice for columns that undergo frequent changes because this results in the entire row moving (because SQL Server must keep the rows data values in physical order). This is an important consideration in high-volume transaction processing systems where data tends to be volatile."

Hope this helps,

Eric

-- Anonymous, February 24, 2000