Secondary Index on multiple columns
Posted: Mon Jun 20, 2005 7:44 am
Hello,
Is it possible to create a secondary index on multiple columns of a hash file that was created using mkdbfile command (that is, in a directory).
I have a hashed file, that has been hashed on columns A and B and has data columns C,D,E,F.
Now i have a requirement to look up this hash file based on columns C and D. How do i do this? Is the method of creating secondary indexes advicable? if so how do i create indexes on multiple columns for file that have been created using mkdbfile command.
Thanks
Dhiraj
Is it possible to create a secondary index on multiple columns of a hash file that was created using mkdbfile command (that is, in a directory).
I have a hashed file, that has been hashed on columns A and B and has data columns C,D,E,F.
Now i have a requirement to look up this hash file based on columns C and D. How do i do this? Is the method of creating secondary indexes advicable? if so how do i create indexes on multiple columns for file that have been created using mkdbfile command.
Thanks
Dhiraj