29 Dec
2011
29 Dec
'11
2:51 p.m.
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512
Hi,
MonetDB 'deduplicates' strings, is there any benchmark that outlines the performance difference of an ENUM with a low number of (string)items versus the use of a VARCHAR field?
The technical question would be;
Is it more efficient to do:
select * from my_table, my_enum where mytable.my_enum_id = my_enum.id and my_enum.name = 'Something';
or
select * from my_table where my_enum_varchar = 'something';
I can imagine that the following would out perform a string comparison, but implies hardcoded values.
select * from my_table, my_enum where mytable.my_enum_id = hardcoded;
Stefan
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.18 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
iEYEAREKAAYFAk78fnkACgkQYH1+F2Rqwn3BUQCeOUtPIGzcHT1xpnsF4n78BQ/1
JWAAnjnzPeT8D7CtsjYgAiGg/WRIgNbQ
=989f
-----END PGP SIGNATURE-----