Hello Friends,
I have a database that has 3 numeric fields likes:
N1 N 16 0
N2 N 16 0
N3 N 16 0
and I need to make a lot of indexes like
INDEX ON Str(n1)+Str(n2)+Str(n3) TAG "n1n2n3" TO myindex
INDEX ON Str(n2)+Str(n1)+Str(n3) TAG "n2n1n3" TO myindex ADDITIVE
INDEX ON Str(n3)+Str(n2)+Str(n1) TAG "n3n2n1" TO myindex ADDITIVE
INDEX ON Str(n1)+Str(n3)+Str(n2) TAG "n1n3n2" TO myindex ADDITIVE
INDEX ON Str(n2)+Str(n3)+Str(n1) TAG "n2n3n1" TO myindex ADDITIVE
INDEX ON Str(n3)+Str(n1)+Str(n2) TAG "n3n1n2" TO myindex ADDITIVE
INDEX ON Str(n1)+Str(n2) TAG "n1n2" TO myindex UNIQUE
ADDITIVE
INDEX ON Str(n2)+Str(n1) TAG "n2n1" TO myindex UNIQUE
ADDITIVE
INDEX ON Str(n1)+Str(n3) TAG "n1n3" TO myindex UNIQUE
ADDITIVE
etc.
but I would like to reduce index keys dimension. Is there an algorithm that
give me compact indexes ?
I have thought to convert numeric decimal values in hex values, but I have
to store same 16 chars for every fields. Or am I in wrong ?
TIA
Francesco
_______________________________________________
Harbour mailing list
Harbour@harbour-project.org
http://lists.harbour-project.org/mailman/listinfo/harbour
