Query performance: single column and multiple columns

Question

Which table structure is best among below 2?

OR

In the first query, I use the operator LIKEin the query. In the second, I use the operator AND.

Does the first table design have any advantages over the second when selecting data? In what situation do I need to decide between the first table structure and the second?

Answer 1

The first would be better if you never had to work with attributes Typeor Currency, and you always used all the text saved as MEASUREMENT_NAME.

Type Currency , , , .., .

, MEASUREMENT_NAME, Type Currency . , MEASUREMENT_NAME , . MEASUREMENT_NAME .

, MEASUREMENT_NAME , , , , () , JSON XML, Oracle JSON.

Type Currency, .

Answer 2

, , . , , , , . , / , .