Dan:
From R:Syntax:
Primary Key, Foreign Key, and Unique Key are all type of constraints
that are automatically indexed when added to a table. Avoid indexing
these keys as this creates a double index, and makes R:BASE perform
twice as much work to retrieve the same data.
Best, Bruce
Bruce A. Chitiea | SafeSectors, Inc.
112 Harvard Ave #272 | Claremont CA 91711-4716 | USA
[email protected] | +011 (909) 238-9012 c | +011 (909) 912-8678 f
------ Original Message ------
From: "Dan Goldberg" <[email protected]>
To: "[email protected]" <[email protected]>
Sent: 1/14/2022 7:25:10 AM
Subject: [RBASE-L] - unique key/primary key
Doe a unique key or primary key also act as an index? Just wonder if i
should index a unique/primary key to speed up look ups.
TIA
Dan Goldberg
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014EF2AA18%40EXCHANGE10
<https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014EF2AA18%40EXCHANGE10?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/em32f799b6-8c88-4ea4-a60f-a2be5924f3e2%40pathfinder.
