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

Popular posts from this blog

blackberry 10 - how to add multiple markers on the google map just by url? -

php - guestbook returning database data to flash -

delphi - Dynamic file type icon -