Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

btree primary index vs heap and secondary btree index

34 views
Skip to first unread message

nikosv

unread,
Sep 16, 2022, 8:53:10 AM9/16/22
to
what would be the difference between a table created with storage structure as btree with unique keys and one that is created with storage structure as heap and with a secondary b-tree index on unique keys ? i.e would the retrieval speed vary and what are the pros and cons?
0 new messages