Em 18/07/2017 16:58, Dimitry Sibiryakov escreveu: > 18.07.2017 21:52, Adriano dos Santos Fernandes wrote: >> It will be described as VARCHAR, so real length depends on the algorithm >> used by the user. > > Index is built on full data length, not real one. >
People will not be crazy to create computed index on hashes. They will store hash on field of appropriate length for the given hash and index it. Adriano ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel