Accessing Hashed files using UV stage
Posted: Thu Apr 22, 2004 11:42 pm
Hi,
I am using an UV stage to access a hashed file.Hash file is defined with three keys A,B and C. In which A is of type char and B & C are timestamps.My look up condition to the hashed file(using UV stage) has an equal to (=) contion on column A ,Less Than ( <) condition on column B and greater than(>) condition on column C. This look up is performing very poorly in terms of throughput.
NOw my Question is that whether the UV stage will use the Hashinhg algo rithm to do the look up or do i need to seperately define an index on these fields. Is there any other way to improve the performance. The size of the hash file is around 7 million records.
Thanks,
Dhiraj
I am using an UV stage to access a hashed file.Hash file is defined with three keys A,B and C. In which A is of type char and B & C are timestamps.My look up condition to the hashed file(using UV stage) has an equal to (=) contion on column A ,Less Than ( <) condition on column B and greater than(>) condition on column C. This look up is performing very poorly in terms of throughput.
NOw my Question is that whether the UV stage will use the Hashinhg algo rithm to do the look up or do i need to seperately define an index on these fields. Is there any other way to improve the performance. The size of the hash file is around 7 million records.
Thanks,
Dhiraj