Differences

This shows you the differences between two versions of the page.

--- tips:revmedia:subs13 [2023/11/11 15:28] – bshumsky
+++ tips:revmedia:subs13 [2024/06/19 20:20] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
+====== index, indexing=====
+^Published By^Date^Version^Knowledge Level^Keywords^
+|Revelation Technologies|14 NOV 1989|2.X|EXPERT|index,, indexing|
+==== index, indexing ====
+A sorted list of record keys or the process of creating and
+maintaining such a list.  When you index a field in a file,
+Advanced Revelation creates a two-part list, or index, for
+that field.  One part of the index is the data in the
+indexed field (for example, company name) for each record,
+and the other part is the record key.  The index is sorted
+according to the data in the indexed field.  For example, if
+you index the company name field in a file, the index itself
+is alphabetized by company name.
+Indexing has three advantages:  1) you can access records
+from a data entry window using an indexed field(s) instead
+of record keys,  2) selecting records for reports and other
+processes is faster when you select based on indexed fields,
+because the selection process addresses only the index, not
+the entire file, and  3) sorting records is faster, because
+the index is already sorted.
+Advanced Revelation offers four types of indexes, each with
+different characteristics:  Btree indexes, Cross Reference
+indexes, Relational indexes, and Quickdexes/Rightdexes.