>Hi All,
>
>Ok, I've got a link table that links two, two part primary keys, together. And sense Seek is faster than locate, I need to index on the four part key. How do you build an index on four integers?
>
>Thanks
Specially for integers, you can use bintoc() function:
index on BinToC(int1)+BinToC(int2) tag TwoInts
Length of the key is 8 bytes total.