Hi John, I have a column which contains about 2 million unique integers (total 2M rows). What would would you recommend as the best option to index them for fastest equality query on this column (binary, equality or something else?). I need to use this column only in equality conditions ( this column is being treated as an identifier of the row and therefore I'll not be using this in range operations as well as any aggregate operations).
In general, could you pls help us decide between equality and binary indexing? If instead of integers, I had 2M unique text values, would binary indexing be the best option? Regards, Gaurav
_______________________________________________ FastBit-users mailing list [email protected] https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
