Wednesday, December 12, 2007

Whats That Number?

For those who might not know, the number that you see after the table name in gstat for example (130) is the relation id. For those of you who might not have 100+ tables, you might ask why do you always see 3 digits. Well the answer is as follows:

Numbers 0-127 are reserved for system table relation ids. So 128, 129+, etc., in creation order are used for normal table/relation ids.

Analyzing database pages ...
ACC_CHARGES (130)
Primary pointer page: 264, Index root page: 265
Data pages: 1, data page slots: 1, average fill: 16%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

No comments: