🎴 Flashcard Mode
Oracle Database Administration and SQL
Card1 / 20
Mastered0
Review0
QuestionClick to flip
Using NVL(),TO_DATE (), TO_NUMBER () functions in 'where' clause on non-indexed columns does improve performance
AnswerClick to flip back
A
False
💡 Explanation:
Applying functions like NVL, TO_DATE, or TO_NUMBER on columns in a WHERE clause typically prevents the database engine from utilizing indexes on those columns, degrading performance.