This project has moved and is read-only. For the latest updates, please go here.

LongBinary read

May 9, 2011 at 4:06 PM

If you have a LongBinary column that is > 1024 bytes (so it's in a separate B-tree), does reading any column from the record read the binary column from the separate b-tree or that is that only read if the binary column is read?

May 9, 2011 at 5:57 PM

A separated long-value is only read off disk if you specifically retrieve that column.

May 9, 2011 at 8:44 PM

Excellent. That's what I would have assumed, but you know what they say about assumptions....