Subject | RE: [Firebird-Architect] Index structures |
---|---|
Author | Skopalik Slavomir |
Post date | 2003-06-10T09:27:33Z |
Hi,
My teoretical think:
Small linear index for fast acces (probably slow insert )
It is useful for small tables (aprox. 10 000 records, short PK like smallint).
This table is usualy static but much reading.
Acces to index by split interval algorithm.
Index will be contain sorted values and data pointers.
Slavek
My teoretical think:
Small linear index for fast acces (probably slow insert )
It is useful for small tables (aprox. 10 000 records, short PK like smallint).
This table is usualy static but much reading.
Acces to index by split interval algorithm.
Index will be contain sorted values and data pointers.
Slavek