Rocksolid Light

Welcome to RetroBBS

mail  files  register  newsreader  groups  login

Message-ID:  

He's dead, Jim. -- McCoy, "The Devil in the Dark", stardate 3196.1


devel / comp.databases.ingres / btree primary index vs heap and secondary btree index

SubjectAuthor
o btree primary index vs heap and secondary btree indexnikosv

1
btree primary index vs heap and secondary btree index

<b3deb486-a510-4f39-8556-e780bbc4e54bn@googlegroups.com>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=259&group=comp.databases.ingres#259

  copy link   Newsgroups: comp.databases.ingres
X-Received: by 2002:a05:620a:4155:b0:6ce:3e56:c1e5 with SMTP id k21-20020a05620a415500b006ce3e56c1e5mr3945415qko.350.1663332789366;
Fri, 16 Sep 2022 05:53:09 -0700 (PDT)
X-Received: by 2002:a05:620a:2907:b0:6ce:80fb:74ca with SMTP id
m7-20020a05620a290700b006ce80fb74camr3719793qkp.171.1663332789156; Fri, 16
Sep 2022 05:53:09 -0700 (PDT)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!feed1.usenet.blueworldhosting.com!peer01.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.databases.ingres
Date: Fri, 16 Sep 2022 05:53:08 -0700 (PDT)
Injection-Info: google-groups.googlegroups.com; posting-host=84.205.251.14; posting-account=HVjXiwoAAABbMuZJSsy6aGtjsYOerfGt
NNTP-Posting-Host: 84.205.251.14
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <b3deb486-a510-4f39-8556-e780bbc4e54bn@googlegroups.com>
Subject: btree primary index vs heap and secondary btree index
From: nikos.vaggalis@gmail.com (nikosv)
Injection-Date: Fri, 16 Sep 2022 12:53:09 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
X-Received-Bytes: 1343
 by: nikosv - Fri, 16 Sep 2022 12:53 UTC

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?

1
server_pubkey.txt

rocksolid light 0.9.81
clearnet tor