Using NVL(),TO_DATE (), TO_NUMBER () functions in 'where' clause on non-indexed columns does improve performance
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- Numeric columns are best suited to define an index (for faster access)
- Which of the following SQL functions can operate on any datatype?
- SELECT (TO_CHAR(NVL(SQRT(59483), “INVALID”)) FROM DUAL is a valid SQL statement
- SELECT (TO_CHAR(NVL(SQRT(59483), “INVALID”)) FROM DUAL is a valid SQL statement.
- NVL ( ) function
- For which relational operators in where clause, index is not used ?
- Instead of Cursor what can be used to perform row by row operation there by increasing performance?
- Why one should not use NULL / NOT NULL operator on indexed columns?