Skip to main content
added 72 characters in body
Source Link
vijayp
  • 2.8k
  • 1
  • 17
  • 20

Option B is a bad choice and to answer you question on performace.

Perfomance wise option A is better choice.

Option A will have simple query where as option B need to run complex sql query.

Option A offers better indexing options which in turn offers better performance.

Option A is neat and clean design.

Perfomance wise option A is better choice.

Option A will have simple query where as option B need to run complex sql query.

Option A offers better indexing options which in turn offers better performance.

Option A is neat and clean design.

Option B is a bad choice and to answer you question on performace.

Perfomance wise option A is better choice.

Option A will have simple query where as option B need to run complex sql query.

Option A offers better indexing options which in turn offers better performance.

Option A is neat and clean design.

Source Link
vijayp
  • 2.8k
  • 1
  • 17
  • 20

Perfomance wise option A is better choice.

Option A will have simple query where as option B need to run complex sql query.

Option A offers better indexing options which in turn offers better performance.

Option A is neat and clean design.