I need to understand how sybase stores data internally, this is what i have understood so far.

  • Every row is stored in a Page.
  • Every Page is made of extent , and every extent is of 8 pages.
  • Every 256 Extent counts to 1 Allocation Unit(Disk Space)

So when i say Root level , intermediate level and leaf level does it only applies to tables for columns where indexes are created or for all tables ?

How would the intermediate level increase ? i.e I have seen in systabstats table there are tables whose indexheight is 5 so how does the index heights gets increased ?