TABLE 1: Results of Sys.partitions Query for Partitioned and Nonpartitioned Tables

name partition_id pnum hobt_id rows
test1 72057594038321152 1 72057594038321152 225
test1 72057594038386688 2 72057594038386688 205
test1 72057594038453334 3 72057594038453334 188
test1 72057594038517760 4 72057594038517760 195
test1 72057594038583296 5 72057594038583296 187
test2 72057594038648832 1 72057594038648832 1000