Kbase P139864: What method does the Progress DB use for indexing?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
20/01/2009 |
|
Status: Unverified
GOAL:
What method does the Progress DB use for indexing?
GOAL:
What method do OpenEdge databases use to build indices?
GOAL:
How are index entries added in the Progress/OpenEdge database?
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
FIX:
Indexes are used to find records in the database quickly.
Each index in an OpenEdge RDBMS is a structured B-tree and is always in a compressed format. This improves performance by reducing key comparisons.
A database can have up to 32,767 indexes. Each B-tree starts at the root. The root is stored in an _storageobject record. For the sake of efficiency, indexes are multi-threaded, allowing concurrent access to indexes. Rather than locking the whole B-tree, only those nodes that are required by a process are locked.