Entity-Attribute-Value. A data model with a potentially big number of attributes of which only few apply to a single entity.

learn more… | top users | synonyms

3
votes
0answers
52 views

Why is an additional filtered statistic being ignored (EAV schema)?

I'm trying to improve a row estimate for this sub-query (of a larger query). The estimate is showing 1266 rows. The actual is 117k rows. This particular property (EAV schema) only has two values ...
0
votes
0answers
28 views

Best way to store combobox options for an EAV table

I don't know if this question belongs to StackOverflow, but here it is: I have an EAV table: mysql> describe keywords; +-------------+--------------+------+-----+---------+----------------+ | ...