Posted: Wed Jul 26, 2006 4:28 pm
What do you mean by "lookup data set"?
A Lookup File Set includes its own index.
A virtual Data Set does not. However, if you look at the record schema you will note that there are four control columns, including partition number, partition count, and row number; these could be used for a "binary chop" style of algorithm. A hint cache could also be used to "remember" recently accessed key values.
A sparse lookup will use any index on the table.
A Lookup File Set includes its own index.
A virtual Data Set does not. However, if you look at the record schema you will note that there are four control columns, including partition number, partition count, and row number; these could be used for a "binary chop" style of algorithm. A hint cache could also be used to "remember" recently accessed key values.
A sparse lookup will use any index on the table.