UV table indices
Posted: Fri Oct 10, 2003 8:32 pm
Hi folks,
if I create a uv-table (using a uv-stage, not a hashfile-stage), I have to specify the columns forming the primary key. Will there be a (primary) index on that primary key columns (Querying this forum gives the impression that an index will not be created)?
Ray mentioned, that secondary indexes created on uv-tables are b-trees. In my understanding, a b-tree index can be used not only if all involved columns are specified in the filter condition, but also, if only a subset of the columns is used. For Example, an index created on col1, col2, col3 is also used by the RDBMS if you would only specify (col1 and col2) or only col1 in the filter criteria? Is this the case for universe as well?
Thank you very much in advance for responses!
Stephan
if I create a uv-table (using a uv-stage, not a hashfile-stage), I have to specify the columns forming the primary key. Will there be a (primary) index on that primary key columns (Querying this forum gives the impression that an index will not be created)?
Ray mentioned, that secondary indexes created on uv-tables are b-trees. In my understanding, a b-tree index can be used not only if all involved columns are specified in the filter condition, but also, if only a subset of the columns is used. For Example, an index created on col1, col2, col3 is also used by the RDBMS if you would only specify (col1 and col2) or only col1 in the filter criteria? Is this the case for universe as well?
Thank you very much in advance for responses!
Stephan