It seems to me that sometimes using hash tables is not required and thus no need to make another expensive JOINs. Especially, when the number of attributes can be foreseen, you can simply set some bit to on. Imagine, we have a product which has two attributes: new, promotion. Usually, we create 2 tables, `Product` […]

Read more...