sql - Table without clustered indexes -
i m trying idea indexes , began this msdn article. says,
when table stored heap, individual rows identified reference row identifier (rid) consisting of file number, data page number, , slot on page.
i have no idea mean "file number, data page number, , slot on page"
can clarify please?
when using clustered table, index records store clustered key (logical identifier) of table record.
say, if use clustered primary table this:
id name 1 jonh 2 alice
and create index on name
, index store data:
name row_pointer alice 2 john 1
if table heap, index store physical pointers table:
name row_pointer alice <file c:\program files\microsoft sql server\mssql10_50.mssqlserver\mssql\data\db.mdf, page 1234, slot 2> john <file c:\program files\microsoft sql server\mssql10_50.mssqlserver\mssql\data\db.mdf, page 1234, slot 1>
(this of course looks more compact in real binary form)
file self-explanatory, page 8k block in file, slot record number in page (the record toc stored in header of each page)
Comments
Post a Comment