Hi folks,
just wanted to check that my understanding of MaxDB internals is correct:
Each table has a primary key (user provided or generated by the DBMS). So
each table is stored as a B*TREE, i.e. the leaf pages of the PK contain
the rows (as opposed to Oracle for example where this is only the case for
tables with option INDEX ORGANIZED; MS SQL Server stores the table as
B*TREE as soon as there is a CLUSTERED (= ordered) index on a table).
Is this correct?
Additional question: how does MaxDB generate the primary key if the user
does not provide one? Does it use some kind of rowid for this? Is there
a storage space overhead associated with this (because of an additional
field)?
Thanks a lot!
robert
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
