Le aplico esta sentencia a la base de datos AdventureWorks, me da como resultado una especie de traza, la cual es la siguiente, cualquier explicacion, pequeña o grande, sera bienvenida, gracias por adelantado:
Result:
Table Person.vStateProvinceCountryRegion Object ID 359672329.
Index ID 1, partition ID 72057594054049792, alloc unit ID 72057594060341248 (type In-row data). FirstIAM (1:19899). Root (1:19901). Dpages 97.
Index ID 1, partition ID 72057594054049792, alloc unit ID 72057594060341248 (type In-row data). 4 pages used in 0 dedicated extents.
Total number of extents is 0.
***************************************************************
Table Purchasing.VendorContact Object ID 382624406.
Index ID 1, partition ID 72057594047299584, alloc unit ID 72057594052739072 (type In-row data). FirstIAM (1:706). Root (1:803). Dpages 0.
Index ID 1, partition ID 72057594047299584, alloc unit ID 72057594052739072 (type In-row data). 2 pages used in 0 dedicated extents.
.
.
.
Result:
Table Person.vStateProvinceCountryRegion Object ID 359672329.
Index ID 1, partition ID 72057594054049792, alloc unit ID 72057594060341248 (type In-row data). FirstIAM (1:19899). Root (1:19901). Dpages 97.
Index ID 1, partition ID 72057594054049792, alloc unit ID 72057594060341248 (type In-row data). 4 pages used in 0 dedicated extents.
Total number of extents is 0.
***************************************************************
Table Purchasing.VendorContact Object ID 382624406.
Index ID 1, partition ID 72057594047299584, alloc unit ID 72057594052739072 (type In-row data). FirstIAM (1:706). Root (1:803). Dpages 0.
Index ID 1, partition ID 72057594047299584, alloc unit ID 72057594052739072 (type In-row data). 2 pages used in 0 dedicated extents.
.
.
.
powered by performancing firefox