I know that when VARCHAR(MAX)/NVARCHAR(MAX) columns are used the data is stored out of the row - the data row will have a pointer to another location where the 'large value' is stored.
I have the following questions:
- Is each field stored
out of the rowor only themaxones? - If you are using the
clustered indexof the table to read the whole record, are fields that are stored out of the row read, too?
VARCHAR(MAX) or NVARCHAR(MAX) is considered as a 'large value type'. Large value types are usually stored 'out of row'. It means that the ...
Aucun commentaire:
Enregistrer un commentaire