Scott Carey <scott@xxxxxxxxxxxxxxxxx> wrote: > I could be wrong, but I think MSSQL only keeps the data specified in > the index in the index, and the remaining columns in the data. Unless it has changed recently, an MS SQL Server clustered index is the same as the Sybase implementation: all data for the tuple is stored in the leaf page of the clustered index. There is no separate heap. The indid in sysindexes is part of the clue -- a table has either one 0 entry for the heap (if there is no clustered index) or one 1 entry for the clustered index. "Normal" indexes have indid of 2 through 254, and indid 255 is reserved for out-of-line storage of text and image data. -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
