Functional Indexes in Oracle
By default oracle creates Btree Indexes but these Indexes are not used if a function is implemented on a column which results in full table scan and can cause performance issues.
Functional Indexes pre compute the values and help in performance Improvements.
Oracle Indexing Playlists
• Indexes in Oracle
#IndexingOracle #TechCoach #functionalIndex #oracleindexes
#index #performanceoptimization