🎴 Flashcard Mode
Science & Technology: Physics, Databases & Search Engines
Card1 / 20
Mastered0
Review0
QuestionClick to flip
Which is a major problem with SQL
AnswerClick to flip back
A
The same query can be written in many ways, each with vastly different execution plans
💡 Explanation:
A major problem with SQL is that the same query can be written in multiple syntactically correct ways, each producing vastly different execution plans and performance characteristics. This makes optimization challenging and query performance unpredictable. SQL does support some object-oriented features, the syntax is designed for professionals, and locking behavior is configurable.